Loading

Sort custom Multi-Select Picklists within List Views

Julkaisupäivä: Aug 29, 2024
Kuvaus

Multi-Select Picklist fields aren't available as to be selected as the sort column in List Views, but the functionality has been requested in the IdeaExchange.

Ratkaisu

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:
 

IF(INCLUDES( Multi_Picklist_1__c , "A"), "A", NULL)  & ";" & IF(INCLUDES( Multi_Picklist_1__c , "B"), "B", NULL)  & ";" & IF(INCLUDES( Multi_Picklist_1__c , "C"), "C", NULL)


Note: If there are several picklists, the formula can exceed the compilation and result in an error.

Knowledge-artikkelin numero

000382650

 
Ladataan
Salesforce Help | Article