Populating a dropdown list (Single select)

Justin Mauzy

Is there a way to populate a dropdown list from a selected option of another dropdown in the same sheet?

I have a columns named: Tech, Team and Supervisor.

If I select Team 1 in the Team column I need it to populate a dropdown for the Tech column with only the techs assigned to Team 1. I have another sheet called Employee Info that has all of the techs and to what team they belong.

• If I select Team 1 in the Team column.
• The dropdown in the Tech column should only have the 10 techs that are on Team 1 as options.
• The Employee Info sheet only has (3) columns named Name, Team and Supervisor.

Is there a way to do this?

Thank you in advance.

Danielle O'Connell

There isn't a way to have the value from one column change what values are in a dropdown picklist. There are ways to use formulas to put in all the names from the team into that column based on what team is selected, but this will not impact what is shown if someone clicks on the cell and views the dropdown selections.

Andrée Starå

Hi @Justin Mauzy

I hope you're well and safe!

To add to Danielle's excellent advice/answer.

As a possible workaround, you could maybe use a form with Conditional Logic instead.

https://help.smartsheet.com/articles/2481701-use-conditional-logic-to-streamline-form-submissions

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Justin Mauzy

Unfortunately, these won't help with what I need to do. Thank for the quick responses though.

Andrée Starå

@Justin Mauzy

You're more than welcome!