A Multiple Select field lets you pick more than one answer from a list. Think of a form that says "check all that apply." A Single Select field holds one answer. A Multiple Select field holds as many as apply.
Here is the test: could one record need more than one of these at the same time? If yes, you want Multiple Select.
Example: a Vendors table with a field called Data Types Accessed. A payroll provider sees employee records and bank details. A support tool sees customer names and email addresses. One answer is never enough, so the field holds several.
The Data Types Accessed field in a vendor record, with Employee PII, Customer PII and Credentials and keys selected.
Plan Availability | All plan types. |
Permissions | Solution Creators and Workspace Administrators can create, modify and manage Multiple Select fields. |
Platform | Web |
Related Reading |
Adding a Multiple Select Field Type
In Grid View, select the + at the right end of the column headers, or open a column menu (⋮) and select Add Field to the Right. From an open record, select the + next to any field instead.
Select Multiple Select. You can type to search the list of field types.
Name the field. In this article it is Data Types Accessed. A field name can hold up to 50 characters, and there is no restriction on the characters it can contain.
The field settings panel opens. It has four tabs: Settings, AI Field Agent, Defaults and Help Text. The rest of this article takes them in that order. Save at any point with Add Field (or Update Field on a field that already exists) and come back to the other tabs later.
The field settings panel, Settings tab, with the four tabs across the top.
Settings
The Settings tab holds the list of choices and the rules around it. Top to bottom: Display Format, Choices, Display Type and Options.
Display Format
How each selected choice looks in a record and in views.
Grey Pill with Color Dot (the default): a gray tag with a small colored dot.
Colored Pill: the whole tag takes the choice's color.
Text Only: plain words, no tag.
Use Colored Pill when the color carries meaning, such as a warm color for a sensitive data type. Use Text Only for long choice names or for views you print.
The Display Format dropdown open, showing the three formats.
Choices
Choices are the answers people can pick.
Type a choice and press Enter. The choice is saved and a new row opens for the next one. + Add New Choice does the same thing.
Each choice gets a color on its own. Select the color swatch to pick another from the 40 available.
Drag a row by its handle to reorder. The A↓ icon sorts the list A to Z in one click; select it again for Z to A. Other always stays last.
Hover over a row to see + (insert a choice below) and - (remove the choice).
A choice name can hold up to 400 characters. Keep names short; a description (see Manage List below) carries the detail.
The order you set here is the order people see in the dropdown, and the order of the groups when you group a view by this field. For Data Types Accessed, that is least sensitive to most sensitive: Public data, Employee PII, Customer PII, Health records, Payment card data, Credentials and keys.
Tip: Put the choices in the order you want people to read them, not alphabetical order. The A to Z sort is one click, so use it only when the list has no natural order.
The Choices section with the six data types, their colors, the drag handle and the A to Z sort icon.
Manage List
The expand icon next to Choices opens Manage List. It shows the same choices with three extra options on the right.
Include Choice Descriptions. Adds a short line under each choice, up to 400 characters. People see it when they pick, so use it where a name alone could be misread. Under Credentials and keys: "API keys, passwords, certificates and service accounts."
Include Value. Gives each choice a number. A Value column appears with 1 in every row; change the numbers to whatever each choice is worth. The number is invisible to the person filling in a record. It is there for formulas, which can add up the values of the selected choices. Data Types Accessed uses it to weight each data type (Public data 0, Customer PII 3, Health records 5), so a formula can score a vendor's risk. The formula is under Formulas, below.
Predefined Lists. Fills the choices from a ready-made list in one click: countries, states, continents, months, days of the week, time zones, task statuses, project phases and more. Use it when the list already exists in the world; type your own when it is specific to your work.
Select Save Choices to return to the panel.
Tip: The choice descriptions and values are sent to the AI Field Agent with its prompt, so a clear description under each choice also makes the agent pick better.
Manage List with descriptions and values turned on.
Display Type
How people pick in a record.
Dropdown (the default): a list that opens when you select the field. Best for long lists.
Checkboxes: every choice is visible all the time, with its description. Best for lists of about six or fewer.
In Grid View, a cell always opens a dropdown, whichever type you pick. You can switch between them at any time. Nothing else about the field changes.
Options
Four switches, all off to start. Each one is a rule for the people who fill in records.
Require an entry in this field. The field shows a REQUIRED label, and a record cannot be saved until at least one choice is picked. Turn it on when a blank means something is missing. For Data Types Accessed, a vendor with nothing selected is a vendor nobody has assessed.
Allow users to create new choices. People filling in a record add a choice with Add New in the list. The new choice joins the field's choices at once, above Other, and is available in all records. Turn it on for an open list, such as Tags. Keep it off for a list someone owns, such as a list of data types kept by Security.
Enable "Other" option. When a person selects Other, a box "Describe why you chose 'Other'" appears under the field. The description is optional. Turn it on when the list cannot cover every case. Review the Other entries now and then; when the same one keeps appearing, add it as a real choice.
Limit number of selections. Caps how many choices one record can hold. Turn it on and a number box appears, set to 1; enter any maximum from 1 up. When the limit is reached, the other choices are grayed out. Use it where more than a few choices would stop making sense, such as Policy Owners with a limit of 2.
Note: Require an entry stops a record from being saved until a choice is picked, so turn it on only where a blank is a real gap.
The Options section with the four switches.
AI Field Agent
Off by default. The field works fully without it. Turn it on to let SmartSuite AI fill the field from instructions you write.
Connection: the AI credential the field uses. The field cannot be saved with the agent on until one is chosen.
Instructions: what you want the agent to do, in plain words, with at least one field from the record inserted as a chip.
Run Automatically: on, the agent runs each time the record is updated; off, it runs when you ask.
An instruction must include at least one field from the record, inserted as a chip with the + at the right of the Instructions toolbar, so the agent reads that field's value. Example for Data Types Accessed, with the Contract Summary field inserted as a chip (shown here in bold): "Read Contract Summary and select every type of data this vendor can see, store or process. Pick only from the options in this field. If the summary names no data type, leave the field empty." The agent maps its answer to the field's choices, and the choice descriptions and values are sent with the prompt, so good descriptions make better picks. A person still reviews what the agent picked. The AI Field Agent article covers connections and instructions in full.
The AI Field Agent tab turned on, with a connection, the instruction for this field and Run Automatically.
Defaults
Default Value(s) picks the choices every new record starts with. You can pick more than one.
Note: Defaults apply to new records only. Records that already exist do not change when you set or change a default.
Use a default for the choice that is almost always true, so the field is never empty and people only add what else applies. For Data Types Accessed, the default is Public data.
Help Text
A note for the person filling in the record, up to 800 characters. Help Text Appearance shows it As A Tooltip (the default, behind an info icon next to the field name) or Below The Field Name (always visible).
Write it for someone who has never seen the field. For Data Types Accessed: "Select every type of data this vendor can see, store or process. Not sure? Pick the closest match and add a comment."
The two Help Text appearances as a person sees them: as a tooltip, and below the field name.
Permissions
Two kinds of permissions apply to this field.
Field Permissions. Every field can carry its own permissions, which control who can see the field and who can edit it. Open the column menu and select Edit Field Permissions. Use it when a field holds something not everyone should see or change; the data a vendor touches might be visible to everyone but editable only by Security. See Field Permissions.
Dynamic Record Permissions. The choices in a Multiple Select field can drive record-level rules: who can see or edit a record based on the values it holds. A rule such as "records where Data Types Accessed has any of Health records are visible only to the Security team" uses the field's choices as the condition. Not every field type can drive dynamic record permissions; Multiple Select can. See Dynamic Record Permissions.
Using the field in views and records
Once records are filled in, the field answers questions across the table.
Filtering
The operators are has any of, has all of, is exactly, has none of, is empty and is not empty. "Data Types Accessed has any of Health records" lists every vendor that sees health records. "Is empty" lists the vendors nobody has assessed.
Grouping
Group a view by the field and a record appears under every choice it holds. Group vendors by Data Types Accessed and the Payment card data group shows every vendor that touches card data, with a count.
Sorting
First to Last follows the order of the choices, so the order you set under Choices is the order records sort in.
Counting and rolling up
A Count or Rollup field, or the group count in a view, tells you how many records hold a choice. The values also work in Auto-Generated Titles, Lookup fields, and in the filters of Count, Rollup and Lookup fields.
Formulas
With Include Value on, a Formula field can total the numbers behind the selected choices. Put this formula in a field called Inherent Risk Score:
SUM(NUMERICVALUE([Data Types Accessed]))
NUMERICVALUE returns the number behind each selected choice. Because a record can hold several choices, it returns a list, and SUM adds the list up. On its own, NUMERICVALUE shows Invalid Formula, because a list is not a number; the SUM around it is the fix. A vendor with Employee PII (2) and Credentials and keys (5) scores 7. A second formula can turn the score into a decision:
IF([Inherent Risk Score] >= 7, "Full assessment", IF([Inherent Risk Score] >= 3, "Standard review", "Questionnaire"))
Without Include Value, formulas can still read the field as text, for example to check whether a choice is present.
Note: NUMERICVALUE on its own shows Invalid Formula, because it returns a list, not a number. Wrap it in SUM, or in another function that takes a list.
Automations
When an automation writes into the field, it sends the values separated by a semicolon: Employee PII; Credentials and keys. An automation can also use the field as a trigger condition, such as running when Health records is added to a vendor. See Working with lists in Automation Actions explained.
Forms
Add the field to a form and the person filling in the form picks from the same choices. What they pick is written to the record when the form is submitted. See Form View.
Editing a Multiple Select field
Add a choice. Open Modify Field Settings, add the choice under Choices (and its value in Manage List if the field uses values), then Update Field. Existing records keep what they have.
Rename a choice. Edit the name under Choices and select Update Field. Every record that held the old name shows the new one.
Remove a choice. Hover over the choice, select -, then Update Field.
Note: Removing a choice changes the field for every record that holds it. Group a view by the field first to see how many records that is. To clear a value from one record instead, open the field in the record, uncheck the choice and select Done.
Change the field type. The dropdown at the top of the panel turns a Single Select field into Multiple Select, or back, without rebuilding it. See Changing a Field's Type.
Frequently asked questions
When should I use Single Select instead?
When should I use Single Select instead?
When a record can only ever have one answer. A vendor's Status is one answer. The data it touches is many.
Why does my formula say Invalid Formula?
Why does my formula say Invalid Formula?
NUMERICVALUE returns a list, not a number. Wrap it in SUM: SUM(NUMERICVALUE([Field name])).
Can I change a value after records are scored?
Can I change a value after records are scored?
Yes. Change the value in Manage List and every formula that uses it recalculates.
How do I load a long list of choices?
How do I load a long list of choices?
Pick a Predefined List in Manage List, or paste the values into the field in a record and they become choices.
Does an Other entry have a value?
Does an Other entry have a value?
No. An Other entry adds nothing to a formula total. Promote it to a real choice with a value when it recurs.
Need more help? Ask the SmartSuite Community, where builders, administrators and the SmartSuite team answer questions about building on SmartSuite. For your account, billing or data, select the chat button in the lower-right corner of SmartSuite to reach support.
Last verified 1 Nov 2026.








