Validation rule: Valid_US_State_Shipping_Address_Abbrev

Name

Valid_US_State_Shipping_Address_Abbrev

Label

Valid_US_State_Shipping_Address_Abbrev

Object

Account

Active

No

Formula

AND (
OR( ShippingCountry = "US", ShippingCountry ="United States",ShippingCountry ="USA", ISBLANK(ShippingCountry )),
LEN(ShippingCity)>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", ShippingState)
))

Error message

A valid two-letter state code is required.

Error location

Account.ShippingCountry