Data Shuttle Not Saving Smartsheets

Penny Wilson

I have been using Data Shuttle for years, using the same Smartsheets and workflows. Suddenly (looks like just since May 1st) my dashboard, which is my end product, is not updating. Here is the way the workflow works:

1. I attach an excel spreadsheet attachment to Smartsheet #1.
2. Data Shuttle #1 merges data from source sheet (Smartsheet #1) into target sheet (Smartsheet #2). The source location is the Smartsheet #1 attachment and it chooses the attachment by Most Recent.
3. It merges data based on a key column value. It adds rows as they are added to the source, deletes rows as they are deleted, and updates rows as they are updated.
4. I filter on Submit Date/Time column that contains 2025 in the field.
5. I have mapped my fields to columns and all column types are Auto.
6. I Run On Attachment and there are no Input Expressions.
7. Smartsheet #2 is used for a report. The report is a widget on a dashboard.

Smartsheet #2 is getting updated but not saving. Therefore, the report and dashboard are not showing updated information. Once I manually go into Smartsheet #2 and click on the Save button everything updates properly. I have 4 workflows in Data Shuttle that do this same thing and none of them are saving until I manually go in and save them. The workflows are running without errors and are actually updating the Smartsheets properly. They are just not saving so updated data is reflected.

Is anyone else having this issue?

Thanks for any input.

Penny

Penny Wilson

Ok. I just figured out what is happening. Data Shuttle #2 (which depends on Data Shuttle #1 being complete) is finishing before Data Shuttle #1. They are all currently set up as Run On Attachment, dependent on Smartsheet #1 attachment. I could schedule Data Shuttle #2 to run at a particular time, giving Data Shuttle #1 time to complete, but that time is a bit arbitrary. It varies as to how long it takes for it to run.

Is there a way to chain the workflows so that #2 doesn't kick off until #1 finishes? I haven't been able to find anything to address this one way or the other, although I'm sure this question has been asked previously.

SSFeatures

Hi @Penny Wilson,

I spent some time trying to think of a way to do this with Smartsheet's current capabilities, but I don't think it's possible.

I recommend submitting a Product Feedback Request so that others can upvote this idea.

Best!