Populating a dropdown list (Single select)

Options

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!