function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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)