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

### 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="/files/ciI8hfyUWFvMLzhLVQ1S" 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="/files/ymmCbHqjwZR01cuVMOMx" 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).*

<figure><img src="/files/0WT0R2FKJYZJIAGV7cE4" 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.
* Multi-select fields will appear as shown below.

<figure><img src="/files/J3eH8rpDCDh7uIgY0PxE" alt=""><figcaption><p>Shows how Google Sheets multi-select fields appear in Table Mapping</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.whalesync.com/connectors/google-sheets/multi-select-fields.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.