function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
NalesNales 

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)
)