Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Adrian-EAdrian-E 

Check if picklist contains certain string

Can I create a validation rule which checks if a value in a picklist object in contains a certain strong?

I have a picklist of the following

 

SMB_Phone

SMB_Email

ENT_Phone

ENT_Email

 

I dont want to reference each value individually - how can I achieve this?

Best Answer chosen by Admin (Salesforce Developers) 
JakesterJakester
This true, but once Spring '09 comes out (within a few weeks, depending on which instance of SF you're on) you can use the TEXT() function to check a picklist. Note that TEXT() will only work on validation rules... for now.

All Answers

MaxaMaxa
you have to do it individually, use AND or OR
JakesterJakester
This true, but once Spring '09 comes out (within a few weeks, depending on which instance of SF you're on) you can use the TEXT() function to check a picklist. Note that TEXT() will only work on validation rules... for now.
This was selected as the best answer
miteshsuramiteshsura

how about INCLUDES function???

eg.: INCLUDES(Hobbies__c, "Golf") returns TRUE if one of the selected values in the Hobbies custom multi-select picklist field is Golf.