If a multi-select picklist with 3 values contains the value Blue, I need to return 1 if only Blue is selected, .5 if Blue plus another value is selected, and .3 if all values are selected. Thanks!
3 answers
Hello @Anne Holland. Try this:
IF(
INCLUDES(MultiSelectPicklistField__c, "Blue"),
IF(
AND(
INCLUDES(MultiSelectPicklistField__c, "Value1"),
INCLUDES(MultiSelectPicklistField__c, "Value2")
),
3,
IF(
OR(
INCLUDES(MultiSelectPicklistField__c, "Value1"),
INCLUDES(MultiSelectPicklistField__c, "Value2")
),
5,
1
)
),
0 // Return 0 if "Blue" is not selected at all
)
