Find your content:

Search form

You are here

How do I compare a formula field with a picklist in a Validation Rule?


I have a custom object with a formula text field on it pulling from the master object. I have a picklist field and upon saving want to check that the picklist value chosen matches the formula text field (both sets of values are exactly the same) - with an error message to advise someone to amend their picklist value choice if they do not match... I am struggling with the syntax - can someone help?

Attribution to: Aileen Lennon

Possible Suggestion/Solution #1

I think this should do it for you:

TEXT(Picklist_Field__c) <> Formula_Field__c

Attribution to: Daniel Hoechst
This content is remixed from stackoverflow or stackexchange. Please visit

My Block Status

My Block Content