We provide the basis for how to achieve validation rule on multi-select picklist values. Use the below code it will help you.
How to use multi-select value in formula field:-
Syntax:-
INCLUDES( Multiselect picklist variable, “values with in quotes”)
For example, here I used validation rule for you need to select at least one subject (multi-select picklist) assigned to student otherwise it will throw an error to ‘select staff name for these subjects’.
We provide the basis for how to achieve validation rule on multi-select picklist values. Use the below code it will help you.
How to use multi-select value in formula field:-
Syntax:-
INCLUDES( Multiselect picklist variable, “values with in quotes”)
For example, here I used validation rule for you need to select at least one subject (multi-select picklist) assigned to student otherwise it will throw an error to ‘select staff name for these subjects’.
Code :-
OR(
IF( INCLUDES( Subjects__c , ‘Tamil’) , true,false) ,
IF( INCLUDES( Subjects__c , ‘English’) ,true,false),
IF( INCLUDES( Subjects__c , ‘Maths’) , true, false),
IF( INCLUDES( Subjects__c ,’Histroy’) ,true, false),
IF( INCLUDES( Subjects__c ,’Geograpy’),true, false),
IF( INCLUDES( Subjects__c , ‘Chemistry’),true,false),
IF( INCLUDES( Subjects__c , ‘Statistics’) ,true, false)
)
We are the ISV Partners and Please reach us for custom development => www.merfantz.com