Workaround for changing values available to select based on what's selected in another column?

Jeff Hickey

I'm needing to be able to provide a 2 columns, both with drop down lists, but the 2nd column needs to change the available values differently based on what's selected in the 1st column. I've seen online where this is not possible with a trigger of add a new row in workflows. I'd love to be able to point the selections to different columns, which I could hide, based on what's selected in the 1st column. This would make it easy to update the drop down values in the future. Thoughts?

Genevieve P.

Hi @Jeff Hickey

Smartsheet dropdowns currently cannot filter and only show specific values based on a selection in a different column. Another Community member posted this as an idea in the Product Feedback Category, here - please feel free to Vote on this post and add your voice to how this feature would be useful for you!

If you're using dropdowns in forms, you could potentially set up multiple columns with your different lists. Then you can use Conditional Logic in forms to only show specific columns (lists) from your sheet based on a previous selection (see: Use Conditional Logic to Streamline Form Submissions)

Cheers,

Genevieve