Drop-down values from another sheet

SSK_REGN

Is there a way I can refer the drop-down values for a field to the data on another sheet?

Andrée Starå

Hi @SSK_REGN

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

There might be a possible workaround.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

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!

SSK_REGN

I have a sheet for storing Resources on a project.. see below:

I have another sheet to capture their timesheet info. See below:

So, when the resource wants to enter the data into the timesheet, I would like to have the Resource Name in the second sheet to be driven by the list of values in the same column of the 1st sheet.

This is a very useful and common requirement for many such systems used in Enterprises. Is there a way to accomplish this?

Andrée Starå

@SSK_REGN

Yes, If I understand you correctly, you can use cross-sheet formulas and either a VLOOKUP or INDEX/MATCH combination to collect the information.

Would that work?

SSK_REGN

But these formulae ( VLOOKUP or INDEX/MATCH) only help to validate the data after the fact, right? I am thinking of having the LOV as the drop-down for that column in second sheet so they can choose the right one.

Or, am I missing something?

Andrée Starå

@SSK_REGN

Yes, but if we have a dropdown list to select from, we can collect the other sheet's information.

Make sense, or do I misunderstand what you need?

SSK_REGN

The need is to generate the drop-down list for the second sheet from the values on the first sheet.

Andrée Starå

@SSK_REGN

Ok. Then you'd need to use one of the following options.

• The premium add-on, Data Uploader

More info: 

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

• Smartsheet API
• 3rd party solution

✅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!

SSK_REGN

Thanks Andree. Does the Uploader has the capability to dynamically sync data between two or more sheets so that a drop-down list for one field in one sheet can be driven automatically using the values of a column from another sheet?

Andrée Starå

@SSK_REGN

Happy to help!

If I understand your questions correctly, no, but it can update the dropdown list selections in multiple places when run.

Make sense?

Would that work?

JF Cornet

Hello there

I saw the comment on this post back from 2020.

Do you know if the requirement (similar to Microsoft Excel Data Validation feature, where user can select in drop down list info from another table) has been scheduled as an enhancement request?

Thank you very much

Andrée Starå

Hi @JF Cornet

I hope you're well and safe!

It surely has, but the more that submits it, the higher up on Smartsheet's radar it becomes.

Please submit an Enhancement Request when you have a moment.

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