How to create dependent drop down lists?
based on the choice selected on this drop down list, the next column should have a dependent drop down list (based on the choice in the previous column's choice).
Answers
-
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could use the Conditional Logic in Forms.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
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.
-
Even the offset function does not exist in Smartsheet to manipulate this demand.
-
I am not sure that Smartsheet will ever put this functionality in. I too have been looking into how to accomplish this, and I see posts requesting this all the way back to 2016 with no update or progress on getting it implemented.
-
You can use the Webhooks and SDK in the developer part, in my company we solve that problem with the API.
-
You can do this in AppSheet
https://help.appsheet.com/en/articles/961554-dependent-dropdown
-
@Robin Herrick does AppSheet work with Smartsheet? And do you have an example of an implementation of this?
-
AppSheet is a no-code app building service which uses Google Sheets to create relational databases. It can also work with Smartsheet as a source of data, but I don't have an example.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!