1

I need to create a validation rule to say if

Mailingcountry = canada then field Canada_Email_Consent__c needs to be completed

Canada_Email_Consent__c = Picklist Mailingcountry = text

1
  • Do you use the State and Country pick list? it will give you easier validation options.
    – Saariko
    Jun 5, 2014 at 18:18

1 Answer 1

1

Try this

AND(
     UPPER(MailingCountry) = 'CANADA',
     ISBLANK(TEXT(Canada_Email_Consent__c))
)
4
  • What happens if they spell Canada, upper/lower case etc?
    – user8746
    Jun 5, 2014 at 14:56
  • You can use both. All UPPER does is make it not case specific. So canada and cAnAdA would both be captured in tehis rule. You can combine the two functionas though. CONTAINS(UPPER(MailingCountry), 'CANADA') Jun 5, 2014 at 15:08
  • 'CANANDA' ? Are you sure you don't mean 'CANADA' ?
    – Jagular
    Jun 5, 2014 at 15:10
  • Yeah yes, it is a typo. No wonder why it wasnt working :P I appreciate your help guys.
    – user8746
    Jun 5, 2014 at 15:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .