function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Synthia BeauvaisSynthia Beauvais 

Workflow Rule with Field Update - Error: Syntax error. Missing ')'

I am trying to create the following scenation but I am getting Error: Syntax error. Missing ')'

If the billing state is AK:AZ:CA:HI:NV:NM:OR:UT:WA the billing country should be "United States".  
IF(CONTAINS(BillingState)(“AK:AZ:CA:HI:NV:NM:OR:UT:WA”, BillingCountry), “United States”))

 
UC InnovationUC Innovation
Hi Synthia,

Here's what the formula should look like:
  
IF(CONTAINS(BillingState, “AK:AZ:CA:HI:NV:NM:OR:UT:WA”) , “United States”, value_if_false)

Replace value_if_false with whatever value you want billingcountry to be if billingstate does not contain “AK:AZ:CA:HI:NV:NM:OR:UT:WA”. In the field to update, you should specify that the field you are updating is BillingCountry. This formula should be under Specify New Field Value.