Validation rule: Valid_US_State_in_Mailing_Address_Abbrev

Name

Valid_US_State_in_Mailing_Address_Abbrev

Label

Valid_US_State_in_Mailing_Address_Abbrev

Object

Contact

Active

No

Formula

AND (
OR( MailingCountry = "US", MailingCountry ="United States",MailingCountry ="USA", ISBLANK( MailingCountry )),
LEN( MailingCity )>0,
NOT(
CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" &
"IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" &
"NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" &
"WA:WV:WI:WY:AS:FM:GU:MH:PW:PR:VI", MailingState )
))

Error message

A valid two-letter state code is required.

Error location

Contact.OtherState