Populate dropdown values based on value in another column
I have two columns (Functional Area and Workstream), there are about a dozen Functional Areas and each has between 1 and 4 Workstreams. What I would like to do is make the valid values for Workstream based on what is selected in that row for Functional Area. Is this possible? Thank you!
Answers
-
It's not currently possible to show/hide values in one specific dropdown column based on a selection in another column in Smartsheet - when you have a moment, please add your Vote and voice to this Idea post: Dynamic dropdowns - Waterfall request
That said, you can conditionally show/hide fields in a Form based on a selection in another column. In this instance you would create multiple Dropdown Columns, each with the specific list associated with your Functional Area. Then in the Form you would only show the relevant column with the associated list using Conditional Logic. I hope that helps!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks for your reply Genevieve, I commented on the Dynamic dropdowns post per your suggestion. I will look into the Form idea as well.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives