Centrally Manage Drop Down Lists for Multiple Sheets

Chann403

I work with a small Real Estate company and we lean heavily on Smartsheet for all of our task and workflow management. We have built a system of task lists, workflows, and meeting agendas that all work very well, but at the moment we have to edit drop-down lists manually sheet-by-sheet. I've searched the community for ways to centrally manage our drop-down lists, and I'm seeing questions about this that date back as far as three years.

This is really important functionality for us and I'm really hoping someone can tell me if we can hope to see this added to Smartsheet in the near future. All of the work-arounds I've found so far unfortunately don't work for us.

If you're unable to create a drop-down list management tool, it could solve the issue if we were able to insert cross-sheet references within a drop-down list. That way, I could create a Drop-Down List Sheet where each column is a drop-down list and each drop down list would refer to that sheet. Hopefully that makes sense...

Does anyone else have any work-arounds I may not have found yet?

Thank you!

Nick Burrus

This is an amazing feature and I wish I could just set a dropdown to pull a list/range from another sheet to make it super easy.

 

The only true way to do this is Zapier.

Chann403

We do use Zapier, but I didn't realize they would have a solution for this issue. Can you tell me a little more about how I could set this up, or how you use it if it is solving a similar issue for you?

Andrée Starå

Hi,

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 DropdownCould that work?

Hope that helps!

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

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

IT_DEPT_TRANSARC

@Nburrus

We also use Zapier and I can't manage tu update drop down list.

Could you please explain me your magic trick to perform this ?

 

(Sorry for bad english)

 

Regards,

 

Hubert