In Salesforce List Views, Multi-Select Picklist fields cannot be used as a sort column. This is a known platform limitation. However, a workaround using a Custom Formula Field (Text return type) allows sorting by creating a text representation of the multi-select values. This feature improvement has been requested on the
in the IdeaExchange.
Workaround:
In either Salesforce Classic or Salesforce Lightning, create a Custom Formula Field with return type as "Text" (with the formula below) and use the field to sort the list view:1.Create a Custom Formula Field with Return Type "Text" using the INCLUDES() function for each picklist value.
For example, a formula that checks for values "A", "B", and "C" would evaluate each value with INCLUDES(), concatenate the results with a semicolon separator, and return NULL for missing values.
2.Replace Multi_Picklist_1__c with your actual field API name and "A", "B", "C" with your actual picklist values.
Note: If there are several picklists, the formula can exceed the compilation and result in an error.
000382650

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.