Can I sort custom Multi-Select Picklists in List Views?
|Knowledge Article Number||000230523|
Multi-Select Picklist fields can't currently be selected as the sort column in List Views, but the functionality has been requested in the IdeasExchange.
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.