-
Data Shuttle Workflow Report for System Admins
December 16, 2025 With this release, Smartsheet System Admins can now download a CSV report containing details on all Data Shuttle workflows in their organization. To access this feature, System Admins can go to the "My Organization" page in Data Shuttle, and then click “Workflow report” to download a CSV file with details…
-
Data Shuttle: Duplicated Data with Different Creation Dates
Hello! I am working on a new Data Shuttle workflow and have come across an issue I haven't encountered before. I have to run an annual audit on a list of employees through a third-party site. I am able to download the query results of the audit from the third-party site, and I would like to use Data Shuttle to add results…
-
Smartsheet Gov- Data Shuttle
I have Smartsheet Gov and am having issues successfully authenticating via smartsheetapps.com to link my OneDrive or SharePoint account. I'm seems as if the page has been removed. Any suggestions?
-
Data Shuttle Offload - Distributed Flag?
Is there a way with Data Shuttle Offload to mark which rows have already been offloaded so they are not sent again? Like a distributed flag? This is for a conference attendee check in. The data shuttle offload would probably run every 2 minutes during the check-in window and I don't want to resend a row. Thank you!
-
Data Shuttle Target sheet contact columns
Are you able to do a workflow process with Data Shuttle where the target sheet column is a contact column and the excel sheet is convert to an email address? Is there a formula or a trick to get the contact information to convert to an email address?
-
Data Shuttle initial set up
I have learned that each one of the Smartsheet add-ons have a specific step that does not seem to be listed in the training tutorial. I am creating a new Data Shuttle workflow and I want to run the workflow as a sheet attachment. This option never seems to appear to begin my process. Do you first have to create the…
-
Data Shuttle source file is password protected
I am using Data Shuttle to import data into a DataTable from an Excel file that's password protected. After the workflow runs there's no data in the DataTable as a result. I've tested the same Data Shuttle workflow with a file that's not password protected, and it works fine. Is there a way to import data from a…
-
Time columns from Excel to Smartsheet via Data Shuttle
I'm trying to Data Shuttle an Excel doc from another system into Smartsheet. All is fine, except for the Start Time and End Time columns. They look like this in Excel: But when I pull them into Smartsheet via Data Shuttle, the columns show only the date part of those columns: I'm really only interested in the time…
-
Data Shuttle to Power BI
I am working on a project for a client, where they want to have dashboards built out for data analytic purposes that update automatically. The client already invested money into data shuttle, so data is automatically going to pull from the different data sources. Given that Smartsheet dashboards have limited analytics…
-
Data Shuttle: Why am I getting this error and how do I fix it?
I download excel from sharepoint and upload it to smartsheet as a new attachment. It was working perfectly fine but about 20 days ago it started showing this error message. What is causing this issue and how do I fix it?
-
Integrating Jotform via Zapier
Hi all, Wondering if anyone has had luck integrating Jotform and Smartsheet via Zapier. We would like to create an action where submissions in Jotform are "shuttled" as new rows to a grid in Smartsheet. Unfortunately Data Shuttle does not support Jotform (at least for us), but could a similar action be created via Zaps?…
-
Integrating Jotform via Zapier
Hi all, Wondering if anyone has had luck integrating Jotform and Smartsheet via Zapier. We would like to create an action where submissions in Jotform are "shuttled" as new rows to a grid in Smartsheet. Unfortunately Data Shuttle does not support Jotform (at least for us), but could a similar action be created via Zaps?…
-
Data Shuttle, Use sheet name to link which tab to reference
The tab number in Excel is easily changed and seems unreliable. In my experience, when the tab number does change, there isn't a method for Data Shuttle to alert you of any issue. It's typically an end user that alerts me that some data appears outdated. Preventing file changes in Excel would be one counter measure, but…
-
Data Shuttle, how to find the right Excel Tab number
Hi all, having some trouble nailing the logic for the tab number and I don't see this in the documentation or in prior questions. First, I assumed the tab number would be the count, left to right, of the visible tabs (3rd one). But that wasn't right. Next I tried looking at the tabs in the VB editor and counting top to…
-
How do I opt-in on large scale sheets (individually) so that I can use Data Shuttle with Tables?
My organization has access to both EAP features and Table View, alongside the increase in limits associated with that. Despite this, one of my colleagues cannot seem to use Data Shuttle to upload more than 20,000 rows worth of data. I've seen bits and pieces of information suggesting a per-sheet/table opt-in, but cannot…
-
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 upload error to client sheet with a locked store id column
Seeing if anyone has a similar experience or guidance. We have two sheets which we are using data shuttle between: • Client project tracker • Internal project tracker We have setup matching column names and types, which we want to use data shuttle to communicate updates between our two sheets. We pull unique store numbers,…
-
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…