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

Last updated

Was this helpful?