Dynamic Dropdown
Hello,
I maintain a Resource Tracker which includes multiple Resource Names and Vendors. Resources are added and removed on a daily basis.
I created a Forecast Tracker for each workstream to update on a monthly basis (total of 12 Workstreams). I'm trying to find a way of keeping both dropdowns 'Resource Name' and 'Vendor Name' up to date.
Is there a way the dropdown could pull information from a source sheet, such as the Resource Tracker.
Thanks,
David
Comments
-
Hello,
It isn't currently possible to populate the dropdown list column values (within the column properties) with values from another sheet in the core application. When you have a moment, submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.
However, you could populate the cells of a dropdown list column with values in another sheet using cross-sheet formulas. To accomplish this, I'd suggest using the VLOOKUP function or the MATCH function inside of the INDEX function.
-
Hi Alejandra,
Thanks for your help. I'll create a request and look into both above.
David
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives