Dynamic dropdowns - Waterfall request

Ian Cooper

The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance.

Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the range of emails on the Employee sheet, as values would be very useful.

Moving to the dropdown column, it would be helpful if we could set some defined values, but if a new value is entered, have that value added into "values" for that dropdown column.

Sara Campbell

I'd also like to see dynamic dropdowns where when the next dropdown narrows into a waterfall. Ex - select Emergency Department and the next column is Job title - it should only show the ones in that department.

bjt0022

Make a conditional dropdown list that dynamically responded to values of other cells

John D'Angelo

It would be great if we could setup the ability for conditional dropdown lists / feilds directly in smartsheet without workarounds in forms/etc.

Sara Campbell

This would be huge for us. We would also like to be able to populate dropdowns via reference sheets so we don't have to edit them every time a job title is added or a department head changes.

Olen Ronning

We love the idea of dynamic dropdowns and are interested learning about different scenarios related to populating dropdown fields from a central data source, dynamically updating them, and supporting cascading or conditional logic based on the selection made. For those that are interested, we would love learn more about your specific needs and how this feature would work best for you. You can schedule time to connect with me at: https://go.oncehub.com/OlenRonning

JulieSTL

Please consider adding a feature that allows you to:

• Select from a drop down in Column 1 - and that choice will then determine which drop down appears in the Next Column.
• I have to assign tasks by company then individuals within those teams and don't want a crazy long list of names.

This would be a great feature

Hunter Brawn

I have a drop-down list whose options I would like to populate from another column in the same table (Parent/Child accounts in a customer database). Is that possible?

Responding to the comment above mine : That logic exists within Forms, have you tried creating an assignment form?

Fabien

I would love to have the possibility of creating a dropdown list for my data based on the selection on another dropdown list. Doing this, the list of the dropdown will be dynamic and change if the data in another cell is changing.

It would be useful to limit the dropdown values of the second column, just to the group that is induced by the first column.

Deanna Copello

is there a work-around for those that do not have the ability to create datatable and NOT us a form?

Katie B

Would like to have data in one column dictate the possible data that can be added to another column and continue that filtering until you are able to access the data desired.

Example:

Job Family -> Job Discipline -> Skills

The ability to select a job family that then lists the associated job disciplines, and the job disciplines allows me to select the appropriate skills for my form or sheet.

TTheobald

Put me in the camp that would love to see Dynamic Dropdowns like in Excel.

Just a basics.....if you choose something in Column A it narrows down your choices in Column B, which narrows down choices in Column C, etc.

Column A - Chevy, Ram, Ford (choose Chevy)

Column B - narrow down to only transmissions for Chevy. (Choose the proper transmission)

Column C - Show the proper documentation for the choices above.

James Fischer

I believe this can be done in Sharepoint Lists/Dataverse + Microsoft Power Apps. You could build your form using that system, then send the data to your Smartsheet grid or access via a connector, bridge or data shuttle, maybe? Just an idea until Smartsheet enables this.

Scott McNeill

I would love to see Dynamic Dropdowns implemented as well. I have a need to track data classified by Functional Area and then the Workstream associated with that area, it would be very helpful to have the values in Workstream filtered based on what is selected in Functional Area. Thank you!

SJGaffney

This would be a very useful tool to be able to select a work type for instance in one column and based on the answer in this column, a sub-work type can then be selected from the next column limited to those related to the selection from the first column.

Jim B

This would be incredibly helpful for us. I would be happy to just be able to reference a column in another sheet - just like you would do with a regular sheet reference to build out my applicable dropdown values. To have the ability to sort or not sort the list within the dropdown properties would be a 'nice to have'.