Single-Select drop down menu autofilling options

acullums
acullums ✭✭
edited 12/09/19 in Formulas and Functions

Hi, 

I am attempting to select an option from a single-select drop-down that will auto-fill the next column. 

I have loaded the formula as a one to one basis, i.e. if 'this person' is selected, populate 'this manager' in the next column. However, I need it to be across multiple employees. So if, this person, this person, or this person is selected, auto-fill this manager. If I attempt to add an 'or' into my formula, I'm getting error messages of UNPARSEABLE or INCORRECT ARGUMENT SET

Here is my one to one formula:

=IF(HAS(Engineer1, "THIS PERSON"), "THIS MANAGER")

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!