-
Data Shuttle Offload from Smartsheet to Google Sheet - Append vs Overwrite
Hi! I am offloading data from a smartsheet with filters into a Google Sheet and I would really like to simply append any new data rather than overwrite. We are using the offload to create a task list where we wll add a notes column to the right, but since it overwrites every offload, we can not use it in that manner. Is it…
-
Data Shuttle Gov Support for Office 365 GCC High
Hi Community, Data Shuttle users in the Smartsheet Gov environment will now be able to create Upload Workflows from and Offload workflows to Office 365 GCC High. For customers in our Gov environment, we do not turn on cloud targets and sources by default. If you would like to access Box, Google Drive, OneDrive, or Office…
-
Create copy of Smartsheet data, scheduled and automated to be used as trendlines
I have created a PowerBI dashboard using smartsheets as the data source. Live updates are working perfectly, and updating data is running smoothly. I have been asked to show a trend line, and progress with these metrics. How can I build a table (or Smartsheet) using snapshot data in an automated workflow using smartsheet?
-
ERROR Data Shuttle : Workflow Execute: [object Object]
Hello everyone, I have been encountering an error for some time on Data Shuttle. This is: "Workflow Execute: [object Object]". But I don't know what it means. Do you think you can help me? Azerty64
-
Licensed User Cannot Access Data Shuttle
Hello! I am the System Admin for my company's Smartsheet account and I have given a licensed user access to all of our Premium Apps, but they are unable to see Data Shuttle. Any idea as to why this is happening and how I can fix it?
-
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…
-
Data Shuttle - Remove row that is no longer is source sheet
I use Data Shuttle to upload current enrollment data for our courses. I have a unique identifier because the source sheet has duplicate entries, but I only need one in entry in Smartsheet. Has anyone come up with a solution to remove the a row that is in Smartsheet, but no longer in your source sheet? Sometimes courses are…
-
Data Shuttle to DataTable: Replace DataTable
I want to create an automated system that maintains my DataTable as an exact replica of a source file. Data Shuttle does not quite do this for a DataTable workflow. In the Data Shuttle workflow for DataTables you can only Add and/or Update data. This can result in rows of data remaining in the DataTable when they are no…
