Validation rule: Valid_Canadian_Province_in_Shipping_Add

Name

Valid_Canadian_Province_in_Shipping_Add

Label

Valid_Canadian_Province_in_Shipping_Add

Object

Account

Active

No

Formula

AND(
OR(ShippingCountry = 'CN',ShippingCountry ="CAN",ShippingCountry="Canada"),
NOT(CONTAINS("AB:Alberta:BC:British Columbia:MB:Manitoba:" & "NB:New Brunswick:NL:Newfoundland and Labrador:" & "NT:Northwest Territories:NS:Nova Scotia:NU:Nunavut:" & "ON:Ontario:PE:Prince Edward Island:QC:Québec:Quebec:SK:Saskatchewan:YT:Yukon", ShippingState)))

Error message

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

Error location

Account.ShippingState