+ Start a Discussion

need help with a simple validation rule

We have a custom required text field called "Locale" for leads.  In addition to being required, I want to validate that it is set to either "US" or "CA" during edit/create.  Any ideas?  Pseudo code looks like this:

if the locale equals US or CA
    allow update/insert
    display error message

Nathan CrosbyNathan Crosby
The validation rule will look something like this and should work just fine. It will return TRUE if neither US or CA is selected

NOT(OR(Locale__c = 'US', Locale__c = 'CA'))
Worked perfectly - thanks very much!