Single-Select drop down menu autofilling options

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")

Find more posts tagged with

Formulas

Project Management

Comments

Mike Wilday

Have you considered doing a vlookup from a new sheet? It might be an easier approach. You'd only have to manage a column of employees, and in column two list their managers. Then do a vlookup from your dropdown cell with a cross-sheet reference to the vlookup table.

If you use an IF formula you are going to have to update that formula everytime a person changes managers, or a new person is added to the team and that would make for a lot of work in your sheet.

Mike Wilday

IF you absolutely want to use a formula, try this method...

IF(OR(Engineer1 = "This person", Engineer1 = "This person", Engineer1 = "This person"), "This manager", IF(OR(Engineer1 = "This person", Engineer1 = "This person", Engineer1 = "This Person"), "This Manager"))

That's going to get unweildy really fast.

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?