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:[email protected] | 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
Check out the Formula Handbook template!
