Multiselect Picklist in Salesforce: How to Create and Use It

A multi-select picklist in Salesforce lets users select multiple values from a predefined list in one field. Salesforce stores the selected values as text separated by semicolons. This format affects how the field works with reports, formulas, imports, and automation.

A multi-select picklist lets users select one or more values from a predefined list. Salesforce displays the selected values in one field, separated by semicolons. For example, selecting two regions might display Midwest;West.

Use this field when a record needs to store multiple related choices. For example, a Contact record might list a person’s product interests, preferred communication channels, or areas of expertise. A custom Session or Registration object could track the sessions a person plans to attend, while a Case record could list the types of assistance a customer needs.

Create the field in Salesforce Setup and configure its values, settings, and page layout.

When users edit a record, Salesforce displays Available and Chosen lists. To select multiple values, hold Ctrl on Windows or Command on Mac while clicking each value. Use Shift to select a range.

If the field does not appear on a record, check the page layout, Lightning record page (including Dynamic Forms, if used), and the user’s field-level security settings.

Salesforce reports display selected multi-select picklist values as a semicolon-separated string. For example, a record with Sales Cloud, Service Cloud, and Marketing Cloud selected shows as Sales Cloud;Service Cloud;Marketing Cloud.

Salesforce reports group records by the complete combination of selected multi-select picklist values, not by individual values.

For example, records containing Sales Cloud;Service Cloud, Service Cloud;Marketing Cloud, and Service Cloud appear in three separate groups. Salesforce does not combine them into one group for Service Cloud.

To count records containing a specific value, use one of these methods:

• Create a filtered report for each value. Use the includes filter operator to find records containing that value.
• Create formula fields. Use INCLUDES() in a Checkbox or Number formula field to identify records containing a specific value. Add the field to your report to group or summarize the results.
• Export the data to a spreadsheet. Split the selected values and count how many records contain each one.

See Salesforce Reports: Cannot Group or Summarize by Multi-Select Picklist Fields to know more.

If you need counts for individual values regularly, see the When to Use Something Else section.

A multi-select picklist lets users select multiple values in one field, such as the Salesforce clouds a customer uses. Salesforce stores these selections as a semicolon-separated string, like Sales Cloud;Service Cloud. SOQL provides specific operators to filter these fields.

Use = and != to compare the entire field value with an exact combination of values. Use INCLUDES and EXCLUDES to check whether specific values are selected or excluded. Within an INCLUDES or EXCLUDES expression, a semicolon between values means AND, while a comma between strings means OR.

The examples use a multi-select picklist named Product Used (API name Product_Used__c) on the Account object. Its values are Sales Cloud, Service Cloud, Marketing Cloud, and Commerce Cloud. You cannot use a multi-select picklist field in an ORDER BY clause.

For syntax details, see the SOQL documentation.

The UI displays multi-select picklist values in the order defined in Setup. SOQL, Apex, and the API return them in the order the values were created. Reordering values in Setup does not change this order.

To change the order returned by SOQL, create new values in the desired order and use Replace to replace the old values one at a time. Wait for each background job to finish before starting the next. 

Test the process in a sandbox first, and follow Multi-Select Picklist Value ordering behavior for the full steps.

Use INCLUDES() to check whether a multi-select picklist contains a specific value. Salesforce doesn’t support TEXT() for multi-select picklists. To display selected values in a formula field, check each value with INCLUDES() and concatenate the results.

Salesforce supports INCLUDES(), ISBLANK(), ISCHANGED(), and PRIORVALUE() for multi-select picklists, subject to context restrictions. ISCHANGED() and PRIORVALUE() work in validation rules and certain workflow contexts, but not in formula fields. Use ISBLANK() instead of the older ISNULL() function.

The second argument of INCLUDES() must be a quoted text literal, not a merge field or function result.

In a validation rule, Salesforce blocks the save when the formula evaluates to TRUE and displays the configured error message.

Examples

This formula returns TRUE if Sales Cloud is selected:

To require at least one selection, use this validation rule and set the error message to “Select at least one product.”

Check the Previous Value

This validation rule checks whether the previous value included Sales Cloud:

To display an Account’s selected values on a related Contact, create a Text formula field on Contact. Use INCLUDES() to check each value and concatenate the results.

The formula separates selected values with semicolons and leaves a trailing semicolon and space. For example, if the Account has Sales Cloud and Service Cloud selected, the Contact displays Sales Cloud; Service Cloud;.

To display each value on a separate line, use BR() instead of the semicolon separator.

Use this validation rule to prevent users from selecting both Commerce Cloud and Experience Cloud:

Set the error message to “Commerce Cloud and Experience Cloud can’t be selected together.”
Commerce Cloud and Sales Cloud can be selected together, but Commerce Cloud and Experience Cloud cannot.

Use this expression as the condition in a validation rule. Add a check for every other value in the picklist. Three selections will be allowed, but four will trigger the error.

For details, see Salesforce Help: INCLUDES and Salesforce Help: Multi-Select Picklist Formula Example.

To check whether a value is absent from a multi-select picklist in Flow, use a Formula resource with the INCLUDES() function and route the Decision based on the formula result. Use the default outcome for records that don’t meet the conflict condition.

For example, a registration flow can check whether a customer selected a region that conflicts with their assigned service area. If the formula identifies the conflicting selection, the flow routes the record to a conflict outcome. Otherwise, it follows the default path.

In Apex, multi-select picklist values are returned as a semicolon-separated string. Use split(‘;’) to separate the values for individual processing.

Test the flow with overlapping value names, different capitalization, and multiple selections before deployment. For alternatives to multi-select picklists, see the Salesforce Admins guide to alternatives to multi-select picklists

In a Screen Flow, add a Multi-Select Picklist component and create a Picklist Choice Set resource. Select the object and picklist field that supply the choices, then assign the resource to the component. The flow uses the field’s configured values, reducing the need to maintain a separate list. The same resource also works with regular picklists.

Setting a multi-select picklist field to a single value replaces its existing selections. To preserve them, use an Assignment element with the Add Item operator to add a new selection. Then use Update Records to save the field.

For example, if Products_Used__c currently contains Sales Cloud and you want to add Service Cloud:

The result is Sales Cloud; Service Cloud.

Before adding a value, check whether it is already selected to avoid duplicates. The Contains operator matches text, not individual selections. For example, checking for Service Cloud can also match Service Cloud Voice.

Use INCLUDES() in a supported Flow formula resource to check for an exact selection:

The formula returns TRUE if Service Cloud is selected, even when other values are also selected. Use the result in a Decision element to skip the assignment when the value already exists.

Replace Record.Products_Used__c with your record variable’s field reference and Service Cloud with the value you want to check.

Test the flow in a sandbox with an empty field, existing selections, and a value that is already selected. Confirm that existing selections remain, the new value is added only once, and the field saves correctly. For restricted picklists, verify that the new value is allowed.

When you update records with Data Loader, Salesforce replaces the existing multi-select picklist value with the value in your file. To preserve existing selections, include them alongside new values, separated by semicolons.

Data Loader replaces the entire multi-select picklist value with the value in the import file. It does not append new selections automatically. In this example, the field is Products Used.

Salesforce displays selected values in the order configured in Setup on record pages and in reports. The order returned by SOQL queries and the API can differ.

Each value in the import file must match a valid picklist value for the record. Restricted picklists reject invalid values. Check the field’s configured values and record type assignments before importing. Avoid extra spaces around semicolons as they can cause value mismatches.

Here, A2 contains existing products and B2 contains new products. TEXTJOIN is available in Excel 2019 and later, Microsoft 365, and Google Sheets. It does not remove duplicates.

Salesforce stores multi-select picklist values as a semicolon-separated string, such as Sales;Service;Marketing.

Excel uses your system’s list separator when saving CSV files. If your regional settings use semicolons, Excel may use them to separate columns, conflicting with the semicolons inside multi-select picklist values.

Value matching: Restricted picklists accept only valid configured values available for the record type. The Data Import Wizard replaces unmatched values with the default value. Data Loader returns an error when a value violates picklist restrictions. Unrestricted picklists can accept values that aren’t predefined.

Quick fix: Change your system’s list separator to a comma, then save the CSV again. This affects other applications. This workaround isn’t specific to Salesforce.

Workaround:

For a restricted picklist, an imported value that is not defined in the picklist can cause the row to fail. For an unrestricted picklist, Data Loader can accept values that are not defined in the picklist. Review the error file after importing and test both settings in a sandbox if needed.

Before changing a multi-select picklist, check how the changes affect existing records, report filters, and automation.

Renaming a picklist value changes its UI label. Keep its API name unchanged to avoid breaking formulas and code. Review report filters that use the old value.

Use Replace to update existing records with another value or a blank value.

To remove a value from picklist options while retaining it on existing records, deactivate it. You can reactivate it later.

Deleting a value runs as a background job for global value sets and restricted picklists. Salesforce emails you when it finishes.

Replacing a controlling picklist value removes its existing dependency settings. Recreate the affected dependencies for the replacement value.

You can convert a custom single-select picklist to a multi-select picklist. When you convert a multi-select picklist to a single-select picklist, Salesforce clears the existing field values on records because the new field supports only one selection. Salesforce also warns that inactive values are lost when you change the field type.

Test the conversion in a sandbox before changing a production field. Review the field’s dependencies and automation, and verify the resulting values before making the change in production.

Multi-select picklists behave differently from regular picklists in reports, formulas, Flow, and data imports.

Use a multi-select picklist when users need to select multiple values without analyzing them individually. Choose an alternative when you need more control over the data.

Some teams retain the multi-select picklist for data entry and use a Salesforce Flow to sync selections with child records. The Flow must also handle deselected values.

A multi-select picklist stores multiple values in one field but behaves differently in reports, formulas, Flow, and imports. Use it for simple data entry when individual values rarely need analysis. Choose separate picklists or related records when you need value-level reporting or additional details.