How can I create drop downs with selections based on a previous column?

rachel1073

For a product management file, I want drop-downs to be limited based on how a previous column is filled out, as it would be a massive dropdown list otherwise.

 

For example, if "fruit" is selected in the "food type" column, I want the next "sub-type" column to have a drop down list for apples, bananas, grapes, oranges, etc. But if the "food type" selection is "vegetables" instead, I want to see a list of veggies.

Andrée Starå

Hi Rachel,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

There is a workaround that could highlight a column with specific drop-down values depending on the previous selection.

Would that work/help?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

rachel1073

That solution wouldn't work for my purposes. I did submit an enhancement request.

 

Is there a way to add headers to drop-down lists? For example, a fruit header (that isn't selectable) followed by the list of fruits, then a veggie header, followed by veggies, etc.?

Andrée Starå

I often add dividers to make it easy to select in a long list, but unfortunately, there isn't a way to make some selections to be not selectable.

Best,

Andrée

 

 

Shaine Greenwood

Hi Rachel—

You might explore the Dynamic View premium add on to see if that accomplishes what you need: https://help.smartsheet.com/articles/2478391-dynamic-view-create-administrate-views