Is it possible to reference another sheet's dropdown list in a formula?

Tony Fronza

I'm working on a formula to reference another sheet, where the other sheet includes various dropdown menu columns. I want the formula to include an IF statement where, when a cell is selected in the sheet, it populates a corresponding dropdown menu from another sheet. I completed the formula, but the dropdown menu does not appear based on a selection as planned.

I saw similar posts referencing Data Shuttle - is that required to do what I'm attempting?

Any help is greatly appreciated!

Andrée Starå

@Tony Fronza

Happy to help!

Then you must use the Premium App, Data Shuttle, Smartsheet API, or a 3rd-party solution.

https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

✅Remember! 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!

Andrée Starå

Hi @Tony Fronza

I hope you're well and safe!

Do you want to get the value from the dropdown list or the cell in the column of the dropdown list?

Be safe, and have a fantastic weekend!

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!

Tony Fronza

Hi, @Andrée Starå!

Hope you're well, also, and thanks for responding to my question so quickly!

I'm looking for the latter. I want the dropdown list to populate, not the value (since it's a reference sheet, it will never list a selected value).

Andrée Starå

@Tony Fronza

Happy to help!

Then you must use the Premium App, Data Shuttle, Smartsheet API, or a 3rd-party solution.

https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

✅Remember! 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!

Tony Fronza

Thanks, @Andrée Starå ! I'll look into the premium add-ons

David Jasven

Hi Tony,

I understand the challenge you're facing with integrating dropdown menus from another sheet using formulas. I had a similar need and found it frustrating when the dropdown menus didn't update as expected. To address this, I developed a solution that allows dropdowns to auto-populate based on a column from another sheet without the need for Data Shuttle.

You can see how it works in this demo video below: If it seems like a good fit for your needs, you can sign up to use this feature.

I'm happy to answer any questions or provide further assistance.

💥 If my response helped solve your problem, please consider marking it as Insightful, Vote Up, or Awesome. It helps the community find solutions more easily!

SMARTSHEET EXPERT CONSULTANT & DEVELOPMENT PARTNER

David Jasven | Workflow and Business Process Consultant / CEO @ Must.do

W: www.must.do | E: smartsheethelp@must.do | WhatsApp: +1 347 380-7697

Feel comfortable to contact me for any help with Smartsheet, integrations, general business process advice, or anything else. I am more responsive on Whatsapp.

https://youtu.be/8AYfwDlMoDg?si=jqPfwd22YIAdDQKh