Get a list value from another sheet

Jonathan Vo · 04/22/18

Hi All,

I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet?

Thanks

Chris McKay · 04/23/18

Hi Jonathan,

Do you need to match the driver name from the first sheet to any criteria on the second sheet? I'm assuming it's not just a straight-up list of drivers but a list that matches something like an ID or location to the corresponding record on the first sheet.

The short answer is yes, it's probably possible to do what you want. But it might be easier to post a snippet or screencap of what you're after to ensure we're both on the same page.

Kin regards,

Chris McKay

Jonathan Vo · 04/23/18

Hi Chris,

Please look at the attachment. I have Drivers sheet includes driver information with name and telephone. And I have a booking sheet which also contains driver name and telephone. The problem is I want the "Driver Name" column in the booking sheet get the value from the drivers sheet. Whenever I have a new driver or remove a driver, I just need to edit the Drivers sheet.

Booking list.png

Chris McKay · 04/23/18

Hi Jonathan,

How do you want the Booking sheet to determine what value should go into the Driver Name column?

Did you want a dropdown with all the names from Drivers sheet? If so, this is not possible as dropdown values need to be specified within the column settings and cannot be drawn from other data.

Kind regards,

Chris McKay

Jonathan Vo · 04/23/18

Hi Chris,

That's exactly what I want. Getting names from Drivers sheet. I saw in another thread that this function will be developed. Do you know when we can have that function in smartsheet?

https://community.smartsheet.com/discussion/drop-down-list-data-column-another-sheet

Chris McKay · 04/23/18

Hi Jonathan,

Unfortunately no I don't. Only the Smartsheet Product Team will be able to answer that.

Kind regards,

Chris McKay

Paweł W · 11/14/18

Hi Chris,

As this is a very important feature for many clients including my company, please find out when this will be implemented.

Best regards

Jules Petitjean · 04/15/19

+1 for this please. I'm trying to make a change request form where a change must be associated with an existing project, listed in another sheet. It's frustrating that this is not possible.

jfrost · 05/02/19

The ability to populate a field's allowable values from another sheet is something that is now becoming mission critical for us. This lack of functionality that has been planned now for over a year is something that may cause us to look at other solutions.

Andrée Starå · 05/07/19

Hi everyone,

Please submit an Enhancement Request when you have a moment to have your vote added

A New Way to Submit Your Feature Requests

To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.

Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Dishant Zinzuwadia · 05/16/20

I am new to smartsheet but feature of automatically populating drop-down list content from another sheet is very important as we will not be able to update in every sheet the value and hence updating it at one place could be able to add or remove the value from the list is must.

Andrée Starå · 05/22/20

Hi @Dishant Zinzuwadia

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

I hope that helps!

Be safe and have a fantastic weekend!

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!

Xavier Cotto · 03/26/21

https://community.smartsheet.com/discussion/comment/73456#Comment_73456

Hi Chris (and all community),

Looping back into this conversation. Not sure if this has been resolved somewhere else, but I'm looking for a way to list all values from a reference sheet into a new sheet, based on a column filter. Very similar to what a Report does, but dropping all results into a sheet that I can edit and work on. List all values, maybe sort alphabetically or sort by a different column filter.

For example: List all Engagement Names from reference sheet when Column A = Epic

Any help is appreciated. Thanks!

David Jasven · 06/27/24

https://community.smartsheet.com/discussion/comment/285132#Comment_285132

I finally out of desperation made the solution 😄

To solve this, I developed a solution that allows dropdowns to auto-populate based on a column from another sheet, making it easier to manage dynamic lists like employee names without the need for premium tools.

You can see how it works in the demo video below:

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!

SMARTSHEET EXPERT CONSULTANT & DEVELOPMENT

David Jasven | Workflow and Business Process Consultant / CEO @ Must.do

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 💚.

https://youtu.be/8AYfwDlMoDg?si=jqPfwd22YIAdDQKh

Get a list value from another sheet

Comments

Help Article Resources

Categories