Creating a series of narrowed down drop down menus...

Mark Silvester

Is there anyway to setup a rule whereby you select from a dropdown menu in one column, then the column next to it gives you a specific dropdown based on your selection and then based on that, the following columns auto-populate.

For example:

Columns

1. Manufacturer 2. Model 3. Device Reference 4. Device Type 5. Price

(1. Click from a dropdown). (2. Based on that choice I am given a specific dropdown). (3. the next columns auto-populate based on those two choices)

I have a master sheet that I am operating in and created a separate sheet where all the device information lives that I would like to be used for narrowing down choices and auto-populating. I originally played around with the VLOOKUP formula but was getting far too confused.

Any help or advice would be much appreciated.

Jeff Reisman

You have to buy the Dynamic View add on module. It's the only way to do that with this product.

https://www.smartsheet.com/marketplace/premium-apps/dynamic-view

Andrée Starå

Hi @Mark Silvester

To add to JReisman27's excellent suggestion of Dynamic View.

More info: 

https://www.smartsheet.com/product/dynamic-view

There might be a workaround or a third-party option.

How many different combinations can there be?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD