Dynamic Dropdown

davidmartin95826

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

Alejandra

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.

davidmartin95826

Hi Alejandra,

 

Thanks for your help. I'll create a request and look into both above.

 

David