Excel cascading list function
Hello,
I would like to use the Excel cascading list function on a Smartsheet sheet. Is it possible?
Thanks for your help!
Answers
-
I am not very familiar with cascading lists in Excel, but I am pretty familiar with Smartsheet. Are you able to explain how the functionality works, and maybe we can come up with something based on that?
-
The idea is to be able to create lists that depend on each other.
Example: If I have a single choice column with car brands and a column with models, I would like the model choices in the second column to adapt automatically depending on the brand chosen in the first column.
(if I choose BMW in the first column, the choice in the second column would be only BMW models)
Thank you !
-
That would be something where you would have to explore API or other 3rd party app options. That kind of functionality is not native to Smartsheet.
There is a bit of a workaround that is not the smoothest or cleanest but could help. Basically you would create separate columns where the only available options were those models associated with a particular brand. Then you would use conditional formatting to grey out the columns that don't line up with the selected brand and only leave "un grey" the column with the models that are associated with the selected brand. Not the cleanest or most intuitive, but that's about all that can be done within Smartsheet unfortunately.
Dynamic dropdown lists would be a really nice feature though, so feel free to submit a product enhancement request when you have a moment.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives