Multi-select fields
An explanation of how to set up multi-select fields in Google Sheets
Last updated
Was this helpful?
An explanation of how to set up multi-select fields in Google Sheets
Last updated
Was this helpful?
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.
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.
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.
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).
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.
