October 31, 2024
To improve sheet and Data Shuttle performance, we are changing how Data Shuttle “replace mode” upload workflows function.
Instead of completely deleting and replacing all rows on a sheet, replace mode workflows will now:
- Scan the source data until it detects a change in the data set.
- From that row onwards, Data Shuttle will perform a replacement of all data.
- If no change is detected between the source and target dataset, no rows will be processed.
- If a change is detected on row 1, the dataset will be replaced from row 1.
- If a change is detected in row 99 of 100, only rows 99 and 100 will be processed.
This change will reduce the number of rows impacted when a Data Shuttle workflow runs, while still giving you the same accuracy of results.
As a note, if the source sheet has been reordered since the last workflow run, all rows will be replaced. Replace mode workflows don’t consider row IDs; instead, they compare the source data and ensure a complete match with the target.
Additionally, this will impact the behavior of cell history as only the rows replaced will show as changed in the cell history, instead of all rows on the sheet, which could impact any sheet automations that run based on cell updates.
You can learn more about Data Shuttle upload workflows here.
Environments availability: Commercial US, Commercial EU, Smartsheet Gov
Plan type availability: Business, Enterprise