Conditional Drop-down lists based on another column or field
I am looking to create a conditional drop-down list for a column based off the value in another column. For instance I have a column called Type (Product, Customer, Technology, etc...). Each Type will have its own Categories...
Product (Print, Digital, Service)
Customer (Private, Public, Government)
Technology (HMTL, PHP, Python, SQL)
If I select Type: Product I only want to see categories related to Product, Customer = Customer categories, etc...
paul e. reeves
Principal Business Analyst
HMH
Best Answer
-
I am not sure how to do this so I would be interested to hear if there is a way to do it as well.
I have just had a separate column for each dropdown list and then used the join function to bring it all into one. In the form you can use conditional formatting to only show the correct drop down column based on the first category.
Answers
-
I am not sure how to do this so I would be interested to hear if there is a way to do it as well.
I have just had a separate column for each dropdown list and then used the join function to bring it all into one. In the form you can use conditional formatting to only show the correct drop down column based on the first category.
-
Hi All, are there any updates to this question? I am in need of conditional drop-down lists in many of my workflows and project schedules.
thanks,
Kelli
-
I would like an answer to this as well -EB
-
Hi @M1S
This is currently a feature request that is being tracked by the Product team on this thread, here:
Please add your voice and your vote to explain how you envision this working and what your use-case would be!
Thanks,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Conditional drop-down lists seems like something a lot of users are asking for, and would be top of the list on Smartsheet's product backlog. Any potential dates for when this functioanlity would be released?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!