Populating a dropdown list (Single select)
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.
Help Article Resources
Check out the Formula Handbook template!