Dynamic Dropdown List

ShelbyWarren

Has anyone created a workaround or built a solution that provides dynamic dropdown lists?

Andrée Starå

@ShelbyWarren

A while back, I developed a solution using Data Shuttle and a Directory Sheet that, in turn, would be updated and then updated dropdown list where needed/used.

Here's a helpful article on the subject.

https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

Would that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @ShelbyWarren

I hope you're well and safe!

It depends on what you mean by it. Can you elaborate on the use case?

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

ShelbyWarren

@Andrée Starå The scenario could be either:

1. Multiple sheets with dropdown lists that need to be updated as employees onboard or offboard
2. One Master Sheet that contains a "Directory" of employees that is used to auto-populate dropdown menus in various sheets.

Andrée Starå

@ShelbyWarren

A while back, I developed a solution using Data Shuttle and a Directory Sheet that, in turn, would be updated and then updated dropdown list where needed/used.

Here's a helpful article on the subject.

https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

Would that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

BStump

@Andrée Starå is there a Data Shuttle example you can share?

Jon Barto

@Andrée Starå

The solution you created... We you able to make the work for a workspace? Meaning say we have a list of subcontractors in our schedule (contact list) we need that contact list to pull off a master list sheet.

Because we are always adding contractors and need to pull off the correct ones. Especially because we have reports built for each subcontractor.

Or do you need to manually set up new sheets with data shuffle?

Andrée Starå

https://community.smartsheet.com/discussion/comment/387647#Comment_387647

Hi,

I hope you're well and safe!

Here's a help article with a similar process.

https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

https://community.smartsheet.com/discussion/comment/390314#Comment_390314

Hi,

I hope you're well and safe!

Unfortunately, each new target has to be set up manually.

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

NourMansour

Hello Everyone, I came up with a solution to this particular problem which everyone can try for free and share feedback https://nojolu.net/tool/dropdown_sync/landing