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:
- I attach an excel spreadsheet attachment to Smartsheet #1.
- 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.
- 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.
- I filter on Submit Date/Time column that contains 2025 in the field.
- I have mapped my fields to columns and all column types are Auto.
- I Run On Attachment and there are no Input Expressions.
- 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