Print this page

Can I sort custom Multi-Select Picklists in List Views?

Knowledge Article Number 000230523
Resolution

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.

 

Current workaround

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.





promote demote