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?

  • Are you getting a syntax error? Posting your current validation rule and any errors would help. – Mike Chale Oct 11 '12 at 16:37

I think this should do it for you:

TEXT(Picklist_Field__c) <> Formula_Field__c
| improve this answer | |
  • Agree with Dan. ISPICKVAL(Picklist_Field__c, Formula_Field__c) might be another way to roll ! – techtrekker Oct 11 '12 at 16:50
  • 1
    ISPICKVAL won't work as it expects a text literal in the second argument. Fields won't work there. – Daniel Hoechst Oct 11 '12 at 17:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.