Need Help Linking a Column Between Two Sheets with Dropdown Selections

Mandy L

Hi Smartsheet Community,

I’m looking for guidance on linking a column between two Smartsheets while ensuring that the linked column in the destination sheet functions as a dropdown selection that updates dynamically as the source sheet changes.

Here’s what I need:

• Source Sheet: Contains a column with dropdown values that may change over time.
• Destination Sheet: Needs to reflect the dropdown list from the source sheet and update automatically if the source list changes.
• I want the destination column to remain a dropdown selection rather than static text.

I've explored cell linking and cross-sheet formulas (INDEX, JOIN, etc.) and was using this formula:

=INDEX({{Oak Medical Facility Details Master List U Range 1}}, MATCH([@ID], {{Oak Medical Facility Details Master List U Range 1}}, 0))

Any suggestions or best practices would be greatly appreciated!

Thanks in advance! 🚀

Kerry St. Thomas

The Premium App Data Shuttle is your answer.

Shuttle allows one to upload data, to offload data, or to update dropdowns in a column. I'm thinking that you can establish a Data Shuttle that offloads the Source sheet on a regular cadence - and saves as an attachment to your destination sheet. That attachment save can then trigger another Data Shuttle flow that will do the dropdown updating. This way you'll have the history of what was changed and in what timeframe. More info on Data Shuttle:

https://www.smartsheet.com/marketplace/premium-apps/data-shuttle?srsltid=AfmBOoqHoleZ4basosbdc88N1y6VlxzmEKVBHzRF2W_J2nGlMeqqCR2o

Good luck!