Tell me more ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.
up vote 3 down vote favorite

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?

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

1 Answer

up vote 6 down vote

I think this should do it for you:

TEXT(Picklist_Field__c) <> Formula_Field__c
share|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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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