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)
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
Post a Comment