Is it possible to reference another sheet's dropdown list in a formula?
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!
Best Answer
-
Happy to help!
Then you must use the Premium App, Data Shuttle, Smartsheet API, or a 3rd-party solution.
✅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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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).
-
Happy to help!
Then you must use the Premium App, Data Shuttle, Smartsheet API, or a 3rd-party solution.
✅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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks, @Andrée Starå ! I'll look into the premium add-ons
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!