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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!