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
  • Agree with Dan. ISPICKVAL(Picklist_Field__c, Formula_Field__c) might be another way to roll ! 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. 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.