Multi-select fields

An explanation of how to set up multi-select fields in Google Sheets

You can now use Whalesync to 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

Step 1: Label the multi-select column

• Rename the column in your Google Sheet using the format: multi_[column name]. 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: 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: 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