> For the complete documentation index, see [llms.txt](https://docs.whalesync.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.whalesync.com/connectors/google-sheets/multi-select-fields.md). # 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]`.\ \&#xNAN;*Example: If you're tracking tags, name the column `multi_Tags`.* * A multi-select "Frequented Cities" column is shown below.

**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).*

**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.