Sourcing drop down list

Ryan Fauquier · 02/12/20

Is it possible to reference a list of cells inside a sheet to use as the dropdown list options in a column?

This way if I have multiple sheets that use the same list of options I can reference that list and if it needs to be updated it only has to be done once rather than at each drop down column?

Andrée Starå · 02/12/20

Hi Ryan,

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

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

As possible workaround, you could use a paid add-on. Is that an option?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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!

Dominic Woodley · 02/23/20

Hi Ryan, we have an paid app add-on that will allow you to do this, please contact us at solutions@projectplanservices.co.uk,

cheers Dan

Paul Newcome · 02/24/20

There is another solution that utilizes cell linking. It is not able to be used in the mobile app, and you would have to pre-populate rows to allow for new entries, but it is free.

Andrée Starå · 02/24/20

@Paul Newcome, Yes, how could I forget about that one. 😉

@Ryan Fauquier, Paul is thinking about a solution that used as a workaround. I'll get back to the post with the link and more information.

Andrée Starå · 02/26/20

@Ryan Fauquier,

Here it is!

Here is a workaround I've created that gives you the possibility to use lists of information and choose from that list inside a sheet (doesn't work with mobile, only desktop) (maybe could work now with iOS13, haven't tested it yet)

I'm utilizing cell-linking for this workaround. The main sheet is linked to the dropdown/list sheet.

Please see the attached link/screenshot for more information.

Example of dropdown/list

Here's a link with a better explanation on how it's done.

Link Reference Sheet Dropdown Could that work?

Hope that helps!

Let me know if you have any questions or if I can help you with anything else!