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!了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking 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

✅了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking 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!了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking 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å

@Andrée Starå<\/a> is there a Data Shuttle example you can share?<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"Andrée Starå\",\"userID\":8888}}},{\"insert\":\" is there a Data Shuttle example you can share?\\n\"}]","format":"rich","dateInserted":"2023-07-27T19:21:31+00:00","insertUser":{"userID":159779,"name":"BStump","title":"","url":"https:\/\/community.smartsheet.com\/profile\/BStump","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!cujqB1-W9go!xFsrMbvl6Mo!D9rNxJuoFT5","dateLastActive":"2023-08-11T20:35:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387647#Comment_387647","embedType":"quote"}"> 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

✅了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking 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å

@Andrée Starå<\/a> <\/p>

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. <\/p>

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

Or do you need to manually set up new sheets with data shuffle?<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"Andrée Starå\",\"userID\":8888}}},{\"insert\":\" \\nThe 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. \\nBecause we are always adding contractors and need to pull off the correct ones. Especially because we have reports built for each subcontractor.\\nOr do you need to manually set up new sheets with data shuffle?\\n\\n\"}]","format":"rich","dateInserted":"2023-08-11T20:14:56+00:00","insertUser":{"userID":144391,"name":"Jon Barto","url":"https:\/\/community.smartsheet.com\/profile\/Jon%20Barto","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-16T15:03:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390314#Comment_390314","embedType":"quote"}"> 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

✅了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking 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!