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?
1 Answer
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, 2012 at 16:50
-
1ISPICKVAL won't work as it expects a text literal in the second argument. Fields won't work there. Oct 11, 2012 at 17:10