-
Hyperlink manual trigger data shuttle workflow
As of now the data shuttle workflow can only manual trigger in the data shuttle page by clicking on "Run". My idea is to allow user to trigger running a workflow by hyperlink/webhook. So user can add the link in their dashboard as a function of Button. To manual trigger the data shuttle workflow when they are reviewing the…
-
Anyone else having TIME-OUT failures in Data Shuttle?
Since yesterday we are experiencing multiple data shuttle workflow running over 30min.→2h. mostly it runs 1-3 minutes… It seems data shuttle is very unstable and uncosistently running currently, when I ask copilot it means is Smartsheet backend has a temporary outage or degraded performance. However on the smartsheet…
-
What is the best practice for referencing data in another sheet?
I currently have a Data Shuttle updating/replacing all cells in sheet 1. In a second sheet I have a formula that performs an Index/Match with the result coming from that first sheet. I noticed the cell history on the second sheet is capturing the first sheet values disappear and then come back in (example below). Assuming…
-
Data Shuttle error message, locked resource
I keep getting this Smartsheet Data Shuttle message, "The workflow has been executed with an error. The resource you are attempting to access is locked" I am not in the sheet. Why? I am the owner of these worksheets. What do I need to do to resolve? Sometimes the error resolves itself though.
-
Keep Search Text in Data Shuttle Workflows List
I have well over 100 Data Shuttle workflows, and they are cumbersome to work with. I appreciate the ability to search, but I've found that I have to re-enter my text in the search field over and over again as I'm moving in and out of workflows. If I click into a workflow to view something, when I return to the main…
-
Merged: DataShuttle functionality
This discussion has been merged.
-
Importing Data into existing sheet
Anyone know the benefit of using data shuttle when the only option is to import from another Smartsheet? Why cant I use it to import from Excel or CSV? I'm currently importing from excel to a Smartsheet, however each time I do this, the sheet saves with a new name and I have to go retrieve it. This is counterintuitive when…
-
Datashuttle
If user A owns a data shuttle and set it up to save the csv in an offload workflow to that individuals google drive and then user A goes on vacation and user B now is responsible for running the manual shuttle. When user B ran the shuttle, it created a NEW csv offload file. Is that because of the setting having to do with…
-
Rows could not be added to the destination sheet because it did not have enough cells remaining
I have a blank sheet that serves as a "backup" for our main sheet. We have an automation that copies the data from the source sheet to the to the backup sheet once a week. To work around the fact that smartsheet doesn't have a built in way to delete data, we also have a blank excel file that "uploads" to the backup sheet…
-
DataShuttle Error: "Your workflow maps columns that no longer exist."
Hi all! I'm trying to offload data from a Smartsheet grid to an Excel file on our SharePoint (sadly I need the info to be in Excel in order to integrate the data with other software). Each time I try, I get an error message that says "Your workflow maps columns that no longer exist. Please refresh your mapping to remove…