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
Rakshith RamachandraRakshith Ramachandra 

How to implement ANY() in the validation formula?

Something like TEXT(Implementation_Stage__c) = ANY("X", "Y", "Z").

Implementation_Stage__c is a picklist. If it's value is X or Y or Z. Do something.
Best Answer chosen by Rakshith Ramachandra
RatanRatan
If Implementation_Stage__c is multiselect picklist then use like below
  
OR(INCLUDES(Implementation_Stage__c,"X"), INCLUDES(Implementation_Stage__c,"Y"), INCLUDES(Implementation_Stage__c,"Z"))
Or If Implementation_Stage__c is only picklist then use like below 
OR(ISPICKVAL(Implementation_Stage__c,"X"), ISPICKVAL(Implementation_Stage__c,"Y"), ISPICKVAL(Implementation_Stage__c,"Z"))

 

All Answers

RatanRatan
If Implementation_Stage__c is multiselect picklist then use like below
  
OR(INCLUDES(Implementation_Stage__c,"X"), INCLUDES(Implementation_Stage__c,"Y"), INCLUDES(Implementation_Stage__c,"Z"))
Or If Implementation_Stage__c is only picklist then use like below 
OR(ISPICKVAL(Implementation_Stage__c,"X"), ISPICKVAL(Implementation_Stage__c,"Y"), ISPICKVAL(Implementation_Stage__c,"Z"))

 
This was selected as the best answer
Rakshith RamachandraRakshith Ramachandra
Not quite exactly what I wanted. But thanks anyway