DarianVigil
3 years agoQrew Member
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 field
Here's the logic:
If the (Lead - Region) = x then result a
if the (Lead - Region) = y then result b
If the (Lead - Region) = z AND the (EC) = specific user, then c
The last case is because we have a region that is split with two people.
I've tried a few different ways to write this and am getting errors in different spots no matter what way I try. Any insight is helpful!
------------------------------
Darian Vigil
------------------------------
Lead - Region is multiple choice field
EC is a user reference field
Here's the logic:
If the (Lead - Region) = x then result a
if the (Lead - Region) = y then result b
If the (Lead - Region) = z AND the (EC) = specific user, then c
The last case is because we have a region that is split with two people.
I've tried a few different ways to write this and am getting errors in different spots no matter what way I try. Any insight is helpful!
------------------------------
Darian Vigil
------------------------------