+ Start a Discussion
SkeeterSkeeter 

Checkbox Formula off of multi-picklist

Hi,

Is it possible to create a checkbox formula field to check the box if the multi-select picklist field has more than one selection?

Thank you!
Andy BoettcherAndy Boettcher
You could do a series of INCLUDES function wrapped in IF statements like this:

IF(
   IF(INCLUDES(MVPL__c, "Value1"),1,0) +
   IF(INCLUDES(MVPL__c, "Value2"),1,0) +
   IF(INCLUDES(MVPL__c, "Value3"),1,0) +
   IF(INCLUDES(MVPL__c, "Value4"),1,0) > 1,
true, false)