INDIRECT FUNCTION

Jairo López Tapia

Hi, I've been trying to make a drop-down list based on another drop-down list but I can't without the INDIRECT function.

Can someone please help me with this?

Thank you.

Toufong Vang

Dropdown lists in Smartsheet are static. Without a third-party tool, updates to a list has to be manually done.

Alternatively, if your initial data entry is done via a form, then you can create separate dropdown list fields/columns and configure logic on a field to show or hide subsequent fields.

In the example below, my form has 4 dropdown lists. When the form is opened, only the dropdown list "Protein Type" is displayed. One of the other 3 becomes available depending on the user's selection in "Protein Type".

Hope this helps!

Documentation on Smartsheet functions can be found here,

https://help.smartsheet.com/functions

Andrée Starå

Hi @Jairo López Tapia

I hope you're well and safe!

A solution that would be perfect for this use-case is the premium add-on, Data Shuttle.

Is that an option?

More info: 

https://www.smartsheet.com/marketplace/premium-apps/data-uploader

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!