Is there a way to populate a dropdown list from another sheet?

I have a list of employees that change frequently in Sheet 1. I have a dropdown for employee in Sheet 2. Is there any way to populate the dropdown in Sheet 2 with the list from Sheet 1?

Example:

Sheet 2 has a column named Employee.

Sheet 1 has a column setup as a dropdown called Tech.

I want to take all of the names from the Employee column in Sheet 1 and populate the Tech column with the names.

Thanks in advance.

Find more posts tagged with

Accepted answers

All comments

Mark Cronk

Hi @Justin Mauzy ,

Unfortunately Smartsheet doesn't currently have the ability to create dynamic drop down options. I believe there are some 3rd party add on that will but I've never tried them. Someone else may have a creative solution for you.

Mark

Justin Mauzy

Thank you.

Ken Pavell

Has there been any update on this feature?

Andrée Starå

Hi @Ken Pavell

I hope you're well and safe!

No, but you could use the Premium App, Data Shuttle, to populate Dropdown lists.

Is that an option?

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!

Danielle Wilson

Hi @Justin Mauzy - I'd also recommend using Data Shuttle for this! https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

Roger_B

I am doing something similar. What I did is to copy all the data from the sheet I wanted the dynmaic drop down and pasted into a new (unused) column. Then I changed the property of the column to dropdown list and let SS autopopulate the options. I could copy/paste from there so I knew the data would match.

It won't update or link to future data, but it does give you a start that's not a premium feature

Richard

This should be a basic feature of the standard Smartsheet App. Not difficult me thinks. Thanks

Eric88

I second @Richard's comment.

This is a no-brainer feature. Smartsheet already easily links to other sheets. It should be really simple to do so for Dropdown lists.

This should be a standard feature and shouldn't require finding a 3rd party developer to create a workaround.

The lack of this feature causes so much needless aggravation.

@smartsheet - Is this feature being worked on?

Stephen F

So disappointed to read lookup to another sheet is not possible. Why is there a contact list template if it cannot be referenced from another sheet? There is no relational quality to this platform, right?

Meszarj

if I am reading this correctly, the only way to do this is to use a third party add-on (DataShuttle), move the data off Smartsheet and then bring back to a different sheet. Seriously????

jodimseidl

I agree it seems to be a very high stress point. My company will not invest more into datashuttle or the other features so I am at a roadblock. I really like smartsheet as a data handler, but it can be frustrating to create the things I need.

David Jasven

I'm excited to introduce Submit, a tool I developed to seamlessly integrate with Smartsheet and enable dynamic dropdowns. Submit allows you to sync dropdown data from any column in any sheet, making your menus dynamic and context-specific.

Flexibility: Configure dynamic dropdowns from any column across your sheets.
Efficiency: Automate updates to your dropdowns, reducing manual entries and errors.
Enhanced Productivity: Focus more on meaningful work instead of routine data updates.

See Submit in Action!
Watch the video here and see how easy it is to keep your dropdowns updated and accurate.

Looking forward to hearing how Submit helps streamline your smartsheets!

David Jasven

https://community.smartsheet.com/discussion/comment/436850#Comment_436850

Here is your solution

https://www.youtube.com/watch?v=8AYfwDlMoDg&ab_channel=Jasven

Darren Mullen

@David Jasven Is must.do your automation tool that you've developed?

We've also got another great Dropdown manager available too, built on the WeGRID platform:

https://youtu.be/IDMe0vjBCck?si=j1DSZRIL8VaCplem

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.