Sheet Linking

Kimberley Harris

Is there a way to link one sheet to another sheet creating a drop down menu?

Example: I am creating a form, but I want to the staff to be able to select the residents from a drop down menu.

I have the sheet created with the residents information but I cant figure out how to link it to my "forms sheet' so that they are a drop down menu.

Andrée Starå

Hi @Kimberley Harris

Yes, there is, but not natively without an add-on or the Smartsheet API.

A solution that would be perfect for this use-case is the premium add-on, Data Uploader.

Is that an option?

More info: 

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

Would that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Kimberley Harris

Thank you. We do not have the add-on but I will look into seeing if we can have it added to our profile.

Andrée Starå

@Kimberley Harris

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!