INDIRECT FUNCTION
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.
Answers
-
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,
-
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:
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!
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!