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
BN ManjunathBN Manjunath 

Comparison of picklist with multi picklist.

I need to compare the multi picklist value with picklist value in a validation rule. How to achieve this.

Thanks in advance

Manjunath
JLA.ovhJLA.ovh
Such code cannot work as the INCLUDES function is expecting a text literal value, and not a text value 
INCLUDES( MyMultiPicklist__c ,TEXT( MyPickList__c))

I would suggest placing the literal value in the right member 
INCLUDES( MyMultiPicklist__c ,'Value1') && TEXT( MyPickList__c)=='Value1'
If you need to manage this for more values, it will become  
(INCLUDES( MyMultiPicklist__c ,'Value1') && TEXT( MyPickList__c)=='Value1')
|| (INCLUDES( MyMultiPicklist__c ,'Value2') && TEXT( MyPickList__c)=='Value2')
etc...