Data Shuttle - trigger workflows with new row in sheet

Evening all. Problem that I have is that I need a dynamic dropdown working between two sheets (i.e. values in column X in sheet 1 should be dropdown options in column Y in sheet 2).

I've figured out how to do a workaround using Data Shuttle (offload workflow from sheet 1 to a Smartsheet attachment CSV, update dropdown in sheet 2 using an upload workflow).

The one thing I can't figure out is how to trigger the Data Shuttle workflows from the Workflows option in sheet 1.

Here's what I'm trying to do:

Starting state
- sheet 1 - column x: apples, pears, bananas
- sheet 2 - column y dropdown: apples, pears, bananas

user adds new row "grapes" to sheet 1 - column x
trigger offload workflow
trigger upload workflow

Ending state
- sheet 1 - column x: apples, pears, bananas, grapes
- sheet 2 - column y dropdown: apples, pears, bananas, grapes

Find more posts tagged with

Integrations

functionality

Automations

Workflows in Smartsheet

Accepted answers

Paul H

You cannot trigger a Data Shuttle workflow from Smartsheet workflows, you can set you offload workflow to run on a set schedule, I believe every 15min is the smallest you can do

All comments

Paul H

You cannot trigger a Data Shuttle workflow from Smartsheet workflows, you can set you offload workflow to run on a set schedule, I believe every 15min is the smallest you can do

MattWPBS

https://community.smartsheet.com/discussion/comment/323423#Comment_323423

Urgh. You know of any other way to get a dynamic dropdown to work in Smartsheet?

Paul H

No other way that I am aware of

MattWPBS

https://community.smartsheet.com/discussion/comment/323529#Comment_323529

Thanks anyway Paul! Guess this bit's back off to Excel and Sharepoint. 😕

Andrée Starå

Hi @MattWPBS

I hope you're well and safe!

To add to Paul's excellent advice/answer.

Here's a possible workaround or workarounds

Premium App, Bridge
Smartsheet API

Is that an option?

I hope that helps!

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

MattWPBS

https://community.smartsheet.com/discussion/comment/323544#Comment_323544

Thanks Andrée, they might, how easy is the API to work with? Might try to figure it out for the next iteration of this.

Andrée Starå

@MattWPBS

Happy to help!

If you know API, it's easy because Smartsheet's API is well documented.

https://developers.smartsheet.com/

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.