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

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!
Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…