How to use CONTAINS in picklist field using formulas?

Question

Hi Guys,

I want to write a validation in one object. I will have to write on picklist(ISPICKVAL) but i need to implement contains function in picklist field and how to write that. Please provide me some examples.

Thanks,

Mahesh.

Amit Chaudhary · Accepted Answer

You can try like below

CONTAINS(Text( FieldName__C ),"ReadUP")

Tips for Working with Picklist and Multi-Select Picklist Formula Fields

Please check below post.

https://help.salesforce.com/apex/HTViewHelpDoc?id=tips_for_using_picklist_formula_fields.htm&language=en_US (https://help.salesforce.com/apex/HTViewHelpDoc?id=tips_for_using_picklist_formula_fields.htm&language=en_US)

Please let us know if this will help you

Thanks

Amit Chaudhary

Jithin Krishnan · Answer

Hi, You can check like this: CONTAINS( TEXT(picklist__c ), texttocheck) where texttocheck is the string you want to check in the picklist value. Please let me know if you have any doubts. Thanks!

How to use CONTAINS in picklist field using formulas?

Formulas

Aprendizagem relacionada

Mais ajuda