Multiple values from one column, into dropdown options of another column?

Paul Wheeler

I am trying to grab unique job numbers from a column in one sheet (Sheet A), to populate as options for a single select dropdown in another sheet (Sheet B), to essentially be able to have a spreadsheet to create, track and log daily activities of larger projects.

Sheet A (Master list of projects):

Column values to collect: Project Number

Condition: Where status is NOT "Completed"

Sheet B (daily worklog):

Project Number (dropdown list of projects from Sheet A, where the status is NOT "Completed")

Ultimately, I'd like to have this in a form where managers can select a project from the master list, and create smaller daily tasks. Am I over complicating this/going about this the wrong way? I've gotten quite turned around trying to use the INDEX function.

Thank you in advance for any help. From what I've seen, the community here seems quite helpful and professional! 😁

Mark Cronk

Hi @Paul Wheeler ,

Unfortunatley this capability doesn't exist. You can submit an enhancement request at:

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?ss_v=114.0.2

Mark

Andrée Starå

Hi @Paul Wheeler

To add to Mark's excellent advice/answer.

A solution that could 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 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!

PPS Solutions

@Paul Wheeler Hi Paul, take a look at our Drop Down Sync app which may be able to help you https://projectplanservices.co.uk/dropdownsync

Please let us know if you would like a trial

Thanks

PPS