How to Count Number of Selected Items in a Multi-picklist

If we want to see how many selected items in a multi picklist, it would be simple See the below,

IF(INCLUDES( Multi_Picklist__c , “value 1”), 1, 0) +
IF(INCLUDES( Multi_Picklist__c , “value 2”), 1, 0) +
IF(INCLUDES( Multi_Picklist__c , “value 3”), 1, 0) +
IF(INCLUDES( Multi_Picklist__c , “value 4”), 1, 0) +
IF(INCLUDES( Multi_Picklist__c , “value 5”), 1, 0) +
IF(INCLUDES( Multi_Picklist__c , “value 6”), 1, 0) +
IF(INCLUDES( Multi_Picklist__c , “value 7”), 1, 0)

Hope this will be helpful!!!…….

————————————Thank You!!!!!!!!!!!!!!——————————–

Tags:

Leave a Reply