Dynamic Dropdown


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.




  • Alejandra
    Alejandra Employee


    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.