Loading

Sort custom Multi-Select Picklists within List Views

Дата публикации: Jun 16, 2026
Описание

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

 
Загрузка
Salesforce Help | Article