Validation rule: US_Postal_Codes_in_Billing_Address

Name

US_Postal_Codes_in_Billing_Address

Label

US_Postal_Codes_in_Billing_Address

Object

Account

Active

No

Formula

AND(
OR(BillingCountry = "USA",BillingCountry = "United States", BillingCountry = "US",ISBLANK(BillingCountry)),
LEN(BillingCity) > 0,
NOT(REGEX(BillingPostalCode, "\\d{5}(-\\d{4})?"))
)

Error message

Zip code must be in 99999 or 99999-9999 format.

Error location

Account.BillingPostalCode