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.
Answers
-
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.
-
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.
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Unfortunately, these won't help with what I need to do. Thank for the quick responses though.
-
You're more than welcome!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!