How to Implement Dynamic Dropdown among Two Sheets

Cody Holmes

Cody Holmes ✭✭✭✭

07/28/21 in API & Developers

A department wanted a way to take a unique list from a project column in one sheet and use that distinct listing as a dropdown for another sheet, which updated every hour.

I currently run the below script from Python Anywhere on an hourly basis, and I have shared this script so that anyone else can use it as a template for the same business use case.

Tags:

8 ·

Comments

Bassam Khalil ✭✭✭✭✭✭

07/30/21

@Cody Holmes
Great contribution in Smartsheet community, it will help a lot of members.

PMP Certified
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
1 · Share on Facebook Share on Twitter
Andrée Starå ✭✭✭✭✭✭

07/30/21

Hi @Cody Holmes
I hope you're well and safe!
Thanks for sharing!
I usually use Data Shuttle when clients need something similar to this, and they already have or thinking about getting Data Shuttle.
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
1 · Share on Facebook Share on Twitter
Brian Becnel ✭✭✭

02/07/22

https://community.smartsheet.com/discussion/comment/299620#Comment_299620

@Cody Holmes Hi. Can you point me to help documentation on how to use Shuttle to accomplish the dynamic population of a dropdown list for a column?

0 · Share on Facebook Share on Twitter

Categories

Trending in API & Developers

How to obtain sheet "created by" in Bridge for a child workflow
How can I use Bridge API Call OR Get Sheet OR another element to obtain the "Created By" metadata for use in a workflow? I see createdBy in the sheets summary in the SDK: sheetSummary - fields But I don't see it in the output of past runs of either the API Call or the Get Sheet element in Bridge. I see createdDate but not…
How and/or when does a CellLink Object 'status' get updated to 'BROKEN'?
Across our project portfolio, each project has a main project sheet. This sheet has rows added & deleted as tasks are added or canceled from a project. Individual departments have department specific tracking sheets which mirrors the task list in the in main project sheet and certain key values are linked to the main…
URL String - Any common thread between Sheet and Form?
Hi there, I came across a circumstance where someone had a link to the form but forgot where the sheet lives. Is there anything within the URL of the form that can bring you to just the sheet? I tried cutting out the 'form' from the URL, but unsuccessful. TYIA!