Skip to content
View as MarkdownOpen in ClaudeOpen in ChatGPT

Multi-select fields

Sync multi-select fields in Google Sheets by naming the column multi_[column name] and, optionally, setting data validation to allow multiple selections.

Whalesync can sync multi-select fields in Google Sheets. Multi-select allows you to store multiple values in a single cell, such as tags, categories, or any other list of options.

How to Set Up Multi-Select in Google Sheets

Section titled “How to Set Up Multi-Select in Google Sheets”

Step 1: Label the multi-select column

  • Rename the column in your Google Sheet using the format: multi_[column name].
    &#xNAN;Example: If you're tracking tags, name the column multi_Tags.
  • A multi-select "Frequented Cities" column is shown below.
Shows a multi-select field

Step 2 (optional): Set the column as multi-select in Google Sheets

  • In Google Sheets, navigate to Data → Data Validation.
  • Set the column's data validation to allow multi-select.
Shows how to find the Data Validation menu

Step 3 (optional): Add selectable options in the field

  • Enter all the options you want to include in the multi-select field.
  • Check the "Allow multiple selections" box if you want the field to be multi-select.
    • If the box is unchecked, the field will become a single-select field.
  • Tip: Highlight all the rows you want affected in the field except for the header (as shown below).
Shows selection criteria

Step 4: Map the Table and Sync

  • Complete the table mapping in Whalesync, then activate your sync.
  • Multi-select fields will appear as shown below.
Shows how Google Sheets multi-select fields appear in Table Mapping