Dropdown list in a sheet-column- how can I retrieve available values from another sheet?

cboilini

Hello, I'm a beginner and I'm trying to understand how can I handle some "info masters" that will have to be used in dropdown list in several sheets\workspaces.

Which is the best way to have these "info masters" information updated only in a place?

Waiting for suggestions

Andrée Starå

Hi @cboilini

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: 

Data Shuttle

https://www.smartsheet.com/marketplace/premium-apps/data-uploader

Visualize and act on all your data across platforms and systems

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!

David Jasven

Dropdown list in a sheet-column- how can I retrieve available values from another sheet?

cboilini

Dec 13, 2023

Hello, I'm a beginner and I'm trying to understand how can I handle some "info masters" that will have to be used in dropdown list in several sheets\workspaces.

Which is the best way to have these "info masters" information updated only in a place?

Waiting for suggestions

---

View Post

You can see how it works in this video: If it seems like a good fit for your needs, then I am glad I was able to help!!
I'm here to

help if you have any questions or need further assistance.

✅ If my response helped solve your problem, please consider marking it as Insightful, Vote Up, or Awesome. It helps the community find solutions more easily!

David Jasven | Workflow and Business Process Consultant / CEO @ Must.do
SMARTSHEET EXPERT CONSULTANT & DEVELOPMENT

W: www.must.do | E: smartsheethelp@must.do | WhatsApp: +1 347 380-7697

Feel comfortable to contact me for any help with Smartsheet, integrations, general business process advice, or anything else. I am more responsive on Whatsapp.