-
Data Shuttle will not find columns in source file
I am trying to setup an upload workflow where I bring data from an excel spreadsheet into a sheet in Smartsheet. The Data Shuttle workflow will not find the columns in my source sheet. The column headers start on row 2 in my excel sheet but the mapping portion of the workflow builder will not find the columns. Any…
-
Data Shuttle is not finding all columns in the source sheet
I am trying to use data shuttle to upload data from an excel file in SharePoint but when I get to the mapping part, the column names are completely different from the source. Almost as if it is not pulling the data from the sheet I specified, but a different one. I am using the second tab of the excel sheet and some of the…
-
Data Shuttle Data And Automation
Hello, I’m running into an issue where Automations aren’t running in a workspace I created. The workspace is in Table View and uses a Data Shuttle to bring in information from a Google Sheet containing form submission data. The first three columns of the workspace are not linked to any Data Shuttle data, while the…
-
My number format/layout doesn't hold when I do a Data Shuttle offload - how do I change this?
I am trying to figure out how to make it to where my number columns don't change when I offload. I have attached screenshots of what happens when it offloads. I am not able to edit the excel file that it creates. And my column is properly formatted in smartsheet. What is a good way to avoid this?
-
Contact Datatype - Data Shuttle Import Function - Column Property Toggle Question
Hello, I have seen a few posts that have a manual workaround for this problem, but they are all a few years old, so I thought it best to start a new thread. I use data shuttle to import (First Name, Last Name, Email Address) to a sheet I can create a new column "Contact" using the Contact Datatype I can populate "Contact…
-
Is it possible to offload an attachment with Data Shuttle?
Hello, I am working on a workflow in data shuttle where it offloads any rows that have the helper box checked. Most of these rows will also have attachments that are filled with data. I find that when I offload, the attachments do not come over. Is there a way to include/ download/ offload/ export/ the attachments as well?…
-
Add Run on Attachment for DataTable in DataShuttle
Please include a run on attachment option for DataTable in Data Shuttle. A daily up to weekly only option is very limited. We also need monthly, bi monthly, etc. Similar to the custom date automation option in Smartsheet sheets.
-
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…
-
Folders for Data Shuttle Workflows
I have many D.S. Workflows and would like to save them in folders for each sheet their tied to. This way I don't see all the workflows in a long list
-
Data Shuttle - Delete Rows No Longer In The Source File
I am trying to use Smartsheet and Data Shuttle to automate an open order report that we use. Part of the reason that we're trying to switch it over to Smartsheet is that we want it to be a living document, so that our buyers can write their notes for each order and see what is happening with other buyers orders should they…