If formula help - assigning names
Hi! I'm trying to create an IF formula where if certain values appear in the Product or State1 columns, it lists the same of an employee for assignment.
Above are the columns I'm working with. The formula will be in the Employee column. Basically, if Product = Vermont Red, I want to assign Slim Julian. If Product = Carolina Gold AND State1 = NC, I want to assign Paula Smith.
Here's what I've (unsuccessfully) come up with:
=IF([Product@row] = Vermont Red, "Slim Julian", IF(AND([Product@row] = Carolina Gold, [State1@row] = NC, "Paula Smith"))
There will be instances where there is no one assigned.
I keep getting an Unparseable error. What am I doing wrong?
Help Article Resources
Check out the Formula Handbook template!