I'm needing help with a validation rule that if the mailing state/province has a length greater than 2, that I want to require a mailing country code. I think that the validation rule can't get past the first part being true so it won't let me save. Here's where I need your insight:
Originally, I set the formula as LEN( MailingState ) > 2 and it wouldn't work.
Now, I've got the formula updated to LEN( MailingState ) > 2 <> ISNULL(MailingCountry ) and it still won't let me save the record. What are your thoughts?
As an example:
Joe Cool
123 Main St
Ting Tang, Walla Walla Bing Bang 456213
Australia
Address is fictitious and only provided for humor while testing. Not trying to validate foreign country addresses. Only trying to create a rule that if the mailing code is longer than 2 (since the approved us state and province codes are rather lengthy) then require a mailing country. Thanks in advance!
3 answers
Ken,
Try it like this:AND(
LEN(MailingState) > 2,
ISBLANK(MailingCountry)
)
Doug
