You need to sign in to do that
Don't have an account?
Nales
Country Code Validation
Try to get a process in place to auto-populate the US country code based if reps place a US state. No syntax errors however not placing "United States" in the field. Any extra eyeballs trouble shoot this? Thanks in advance.
AND(
OR(BillingState="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" ),
LEN(BillingCountry) = 0,
NOT
CONTAINS ("United States", BillingCountry)
)
AND(
OR(BillingState="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" ),
LEN(BillingCountry) = 0,
NOT
CONTAINS ("United States", BillingCountry)
)