Validation rule: Valid_US_State_Shipping_Address

Name

Valid_US_State_Shipping_Address

Label

Valid_US_State_Shipping_Address

Object

Account

Active

No

Formula

AND (
OR( ShippingCountry = "US", ShippingCountry ="United States", ShippingCountry ="USA", ISBLANK(ShippingCountry )),
LEN(ShippingCity)>0,
NOT(
CONTAINS("AL;Alabama:AK:Alaska:AZ:Arizona:AR:Arkansas:CA:California:" & "CO:Colorado:CT:Connecticut:DE:Delaware:" & "DC:District of Columbia:FL:Florida:GA:Georgia:HI:Hawaii:ID:Idaho:" & "IL:Illinois:IN:Indiana:IA:Iowa:KS:Kansas:KY:Kentucky:" & "LA:Louisiana:ME:Maine:MD:Maryland:MA:Massachusetts:" & "MI:Michigan:MN:Minnesota:MS:Mississippi:MO:Missouri:" & "MT:Montana:NE:Nebraska:NV:Nevada:NH:New Hampshire:" &
"NJ:New Jersey:NM:New Mexico:NY:New York:" & "NC:North Carolina:ND:North Dakota:OH:Ohio:OK:Oklahoma:" & "OR:Oregon:PA:Pennsylvania:RI:Rhode Island:SC:South Carolina:" & "SD:South Dakota:TN:Tennessee:TX:Texas:UT:Utah:VT:Vermont:VA:Virginia:" &
"WA:Washington:WV:West Virginia:WI:Wisconsin:WY:Wyoming:" & "AS:American Samoa:FM:Federated States of Micronesia:GU:Guam:" & "MH:Marshall Islands:PW:Palau:PR:Puerto Rico:VI:Virgin Islands: AA: AE: AP", ShippingState)
))

Error message

Either a valid two-letter state code or the full name of a state is required.

Error location

Account.ShippingState