You need to sign in to do that
Don't have an account?
Andyux
salesforce formula IF TRUE
This works fine
Reading up on different formatting but cant get it! thanks-
IF(CONTAINS("VS:BJ", Owner.Alias), "Legacy", IF(ISBLANK(BillingState), "International", IF(CONTAINS("WA:OR:CA:AZ:NV:IDMT:WY:UT:CO:NM:TX:OK:KS:NE:WY:NE:SD:ND:MN:IA:MO:AR:LA:WI:IL", BillingState), "USA - West", IF(CONTAINS("AB:BC:MB:NT:NU:SK:YT", BillingState), "CAN - West", IF(CONTAINS("DC:OH:MI:IN:KY:TN:MS:AL:GA:FL:SC:NC:VA:WV:PA:PA:NY:ME:ME:VT:NH:MA:RI:CT:NJ:DE:DE:MD", BillingState), "USA - East", IF(CONTAINS("NB:NL:NS:ON:PE:QC", BillingState), "CAN - East", "International"))))))But i need to first evaluate a Checkboxf field.If its TRUE, then should be done, otherwise, continues. So when I add (first line)
IF(Global_Key_Account__c="TRUE"), "Global", IF(CONTAINS("VS:BJ", Owner.Alias), "Legacy", IF(ISBLANK(BillingState), "International", IF(CONTAINS("WA:OR:CA:AZ:NV:IDMT:WY:UT:CO:NM:TX:OK:KS:NE:WY:NE:SD:ND:MN:IA:MO:AR:LA:WI:IL", BillingState), "USA - West", IF(CONTAINS("AB:BC:MB:NT:NU:SK:YT", BillingState), "CAN - West", IF(CONTAINS("DC:OH:MI:IN:KY:TN:MS:AL:GA:FL:SC:NC:VA:WV:PA:PA:NY:ME:ME:VT:NH:MA:RI:CT:NJ:DE:DE:MD", BillingState), "USA - East", IF(CONTAINS("NB:NL:NS:ON:PE:QC", BillingState), "CAN - East", "International"))))))I get Error: Syntax error. Extra ','
Reading up on different formatting but cant get it! thanks-
Your first line should be: There was an unncessary ')' in the first line.
End the last line of the formula with ")".
Mark this as the solution, if it solves your problem.
Thanks
All Answers
Your first line should be: There was an unncessary ')' in the first line.
End the last line of the formula with ")".
Mark this as the solution, if it solves your problem.
Thanks