Count the number of multi-select picklist values selected #inSalesforce

Count the number of multi-select picklist values selected #inSalesforce


Create a formula field returning the number with the following formula:


IF(INCLUDES(sampleMultiselectPLField__c, "samsungTV"), 1, 0) +
IF(INCLUDES(sampleMultiselectPLField__c, "samsungWM"), 1, 0) +
IF(INCLUDES(sampleMultiselectPLField__c, "LGTV"), 1, 0) +
IF(INCLUDES(sampleMultiselectPLField__c, "LGWM"), 1, 0) +
IF(INCLUDES(sampleMultiselectPLField__c, "APPLETV"), 1, 0)+
IF(INCLUDES(sampleMultiselectPLField__c, "APPLEW"), 1, 0)+
IF(INCLUDES(sampleMultiselectPLField__c, "SONYTV"), 1, 0)

Comments