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.