-
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…
-
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?…
-
Data Shuttle Delete Workflows
September 02, 2025 With this feature, Data Shuttle users and System Admins can delete Data Shuttle workflows individually or in bulk from the Data Shuttle dashboard or archive page. Learn More Environments availability: Commercial US, Commercial EU, Commercial AU, Smartsheet Gov (released 09/16/25) Plan availability:…
-
Help Article updates August 2025
Hello Community, We’ve published the following new content. New videos on these topics: How to create a custom welcome page in Create a custom welcome message or help page How to use Approvals in File Library in Approvals in file library How to use File Library in File Library overview How to create a Dashboard in…
-
Data Table Usability: replace all data
The current limitation using Data Table but not being able to replace all data when using Data Shuttle makes Data Table very messy with Data that should not be there any longer. There is also no easy way to remove ALL entries to refresh Data Table (Currently only 100 lines per deletion) , It was also Suggested in the TT I…
-
Data Shuttle error
Sorry, Disregard my question below. I found the culprit. My dropdown columns were restricted. once I removed the restriction, my data sync'd! :) btw, how do I delete a post I created? I looked to delete my post since I resolved my issue, and could not find a a way to delete it. »»»»»»»»»»»»»»»»»»»»»»»»»» I am using data…
-
Data Shuttle connect to OneDrive (generic/shared sharepoint)
Hi Support Team, Is there a way for me to connect to OneDrive & Sharepoint external account using generic sharepoint login? my account is only able to see my personal onedrive sharepoint only at this moment. this is what i try to achieve create offload workflow data shuttle (smartsheet connect and export excel file to…
-
Data Shuttle not adding all rows from excel source sheet
I have an excel sheet with multiple rows (about 60 rows) that I mapped to import to my Smartsheet. When I run data shuttle, it only adds three of the rows. The three rows are random, in that its not the first three rows, or last three rows. I can't figure out why only those rows as they have the same filled columns with…
-
Data Shuttle Upload Google Sheet
Team, Is there a way to use Data Shuttle to import a specific tab in a Google sheet? I know it normally had to be the first tab in the Google sheet. I have a Google sheet with multiple tabs I would like Smartsheet to import.