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

rachel1073
edited 12/09/19 in Smartsheet Basics

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.

Comments