Dynamic dropdowns - Waterfall request

@Olen Ronning This has been a common feature request for Smartsheet since at least 2015 when I first started using Smartsheet. Data Shuttle was Smartsheet's answer to that way back when, but forced a team with a few licenses to pay thousands of dollars per year for the one feature of centrally updated dropdowns and you have to setup workflows for every sheet (i.e. not useful at scale). A simple UX implementation would be allowing cross-sheet references for the "Values" of a Dropdown list column type. That would solve for central dropdowns, but not cascading dropdowns. What would flexibly solve for cascading dropdowns is being able to use the COLLECT function with a cross-sheet reference for the Values of a Dropdown list column type. You'd need to setup a column in Smartsheet for each "cascade" but I think that's preferable from a data structure anyways (so one could reference each category/sub-category of the cascading list discretely in reporting).

All of the stuff in the EAP is interesting, but the lack of development on CORE feature requests that have been around since the beginning of using Smartsheet hurts. There are a ton of examples of these types of requests - copying and pasting multiple formulas, folder permissions, unhide individual columns (aka list of hidden columns), pasting rows at their original nested level, using dates/structured data as column headers, automatic refresh of calculations in reports when changing a value (instead of having to press save and then press refresh with every change), multiple contact names with the same email address, users being able to filter reports and dashboards on their own, filter panes to include rows, custom color themes, color choices beyond shades of 8 colors, pivot tables that aren't a premium add-on, being able to collapse and expand selections/by level rather than only expand/collapse ALL, populate baseline Start/Baseline Finish when adding new rows, conditional formatting using relative references/ranges so you don't have to copy rules for EVERY column, formulas in conditional formatting, "Created" doesn't get overwritten every time an automation runs (created/ created by column has no meaning), and ability to overwrite column formula in individual cells. I am absolutely sure I'm missing really big, obvious ones, but these are what came to mind.

@Marlei thanks for this. We have used this, however it won't help in forms. It would be great if you select an item and based on your selection in that column it filters results on another column.

Hello everyone, I hope you have started off a great 2024.

I'm one of those who eagerly awaits this, but I would like to mention that a few days ago, I found a video on YouTube with an alternative solution that you might find interesting.

Unfortunately, due to time constraints, I haven't been able to try it out, but it seems interesting.

I think there's a fee to see all the details, but I believe you have nothing to lose by watching the video and giving it a try.

I hope you find it useful.

https://www.youtube.com/watch?v=7HaNxyfCAcw

Seen this above- agree- if we could consolidate lists in a column, the point the dropdown columns to use that column.

Hello,

I am pleased to introduce a solution for automatically updating dropdowns. Please take a look at the link below for our SmartDropdown solution, which is officially listed in the Smartsheet marketplace.

SmartDropdown for Smartsheet

For those who are interested, I would love learn more about your specific needs and how this solution could work best for you. Connect with me at :

Contact - Gia Thinh Co.

@Gia Thinh does SmartDropdown do cascading/conditional dropdown lists or just auto update of single drop down lists? It looks interesting, but I'm not sure it's what I'm looking for

We need dynamic dropdowns

When I attended the Smartsheet Conference in 2022 I heard dynamic dropdowns were coming very soon as they were one of the most requested items. I'm really surprised this item is not even listed as "On the Roadmap."