Simple nested IF Statement not working

Question

I need to set a value of a cell based on the value of another cell in the same row, however I keep getting "Incorrect Argument Set" or no value at all.

* Column A is a department
* Column B is manager name, based on department chosen.

I want to achieve the following:

If Column A = Department 1 then Column B = Manager 1, else if Column B = Department 2 then Column B = Manager 2, else Column B = Manager 3

I have the following:

=IF([Department]@row = "Dept 1", "Manager 1", IF([Department]@row = "Dept 2", "Manager 2", "Manager 3"))

Both columns are Text/Number.

Column A is a linked column from another sheet with an intake form.

Paul Newcome · Answer

I don't see any syntax errors in the formula in your original post that would throw that error. Are you able to provide a screenshot of the formula open in the sheet as if you are about to edit it?

Andrée Starå · Answer

https://community.smartsheet.com/discussion/147131/simple-nested-if-statement-not-working

Hi,

I hope you're well and safe!

Try something like this.

=IF(Department@row = "Dept 1", "Manager 1", IF(Department@row = "Dept 2", "Manager 2", IF(Department@row = "Dept 3", "Manager 3")))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with 💡 ⬆️ ❤️ and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏