Data Shuttle - trigger workflows with new row in sheet

MattWPBS

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

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

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

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

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!