Need help with a formula
I need some help with this formula. Using two tables, the formula field (PC Assigned ((User field)) ) lives in the customers table. Lead - Region is multiple choice field EC is a user reference fiel...
Forum Discussion
If(Contains([Lead - Sales Regional manager], "Idaho", Jamie@essolar.com)),
If(Contains([Lead - Sales Regional manager], "Cache", and {Lead-EC], zach@essolar.com, linda@essolar.com))
It's throwing me errors after "Idaho" it's saying the "," is "Expecting )"
------------------------------
Darian Vigil
------------------------------
If(Contains([Lead - Sales Regional manager], "Cache", and {Lead-EC], zach@essolar.com, linda@essolar.com))
It's throwing me errors after "Idaho" it's saying the "," is "Expecting )"
------------------------------
Darian Vigil
------------------------------
try this
IF(
Contains([Lead - Sales Regional manager], "Idaho"), "Jamie@essolar.com",
Contains([Lead - Sales Regional manager], "Cache") and [Lead-EC]=true, "zach@essolar.com",
"linda@essolar.com")
Can you tell me what field type [Lead-EC] is? If it is not a checkbox field then please explain in words what logic you are looking for involving that field.
------------------------------
Steven Shweky
------------------------------
IF(
Contains([Lead - Sales Regional manager], "Idaho"), "Jamie@essolar.com",
Contains([Lead - Sales Regional manager], "Cache") and [Lead-EC]=true, "zach@essolar.com",
"linda@essolar.com")
Can you tell me what field type [Lead-EC] is? If it is not a checkbox field then please explain in words what logic you are looking for involving that field.
------------------------------
Steven Shweky
------------------------------
