# Multi-select fields

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.&#x20;

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

<figure><img src="https://2481481593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtLaMDbvbGOow76E8CnqW%2Fuploads%2FdGHRaF592Z2cqQgswUg7%2FScreenshot%202025-01-11%20162758.png?alt=media&#x26;token=13ec86ca-f02f-456a-9a9f-92a370397de9" alt=""><figcaption><p>Shows a multi-select field</p></figcaption></figure>

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

<figure><img src="https://2481481593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtLaMDbvbGOow76E8CnqW%2Fuploads%2FJPZq4phIl41vwSVd6YbW%2FData%20Validation%202.PNG?alt=media&#x26;token=8ba01446-b3e4-4511-bc9a-286820bde566" alt="" width="346"><figcaption><p>Shows how to find the Data Validation menu</p></figcaption></figure>

**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).*&#x20;

<figure><img src="https://2481481593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtLaMDbvbGOow76E8CnqW%2Fuploads%2F80jGVjWYn3qZSKxF24Lz%2FScreenshot%202025-01-11%20162018.png?alt=media&#x26;token=7642eca4-65fe-4f5f-bb89-002185a4b0a2" alt="" width="159"><figcaption><p>Shows selection criteria</p></figcaption></figure>

**Step 4:** Map the Table and Sync

* Complete the table mapping in Whalesync, then activate your sync.&#x20;
* Multi-select fields will appear as shown below.&#x20;

<figure><img src="https://2481481593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtLaMDbvbGOow76E8CnqW%2Fuploads%2FtiJdmutQcMga2kezYjFK%2FScreenshot%202025-01-11%20162501.png?alt=media&#x26;token=f7d2a525-517a-4f24-9d76-c2688dd8a00f" alt=""><figcaption><p>Shows how Google Sheets multi-select fields appear in Table Mapping</p></figcaption></figure>
