-
Import data directly into existing sheets in table view
February 16, 2026 We've all been there — you have a spreadsheet full of data sitting on your desktop, and you need it in Smartsheet. Until now, importing a file meant reverting back to grid view. Now you can stay right in table view and import your data without ever leaving the view you're working in. Now you can import…
-
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…
-
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…
-
Data Shuttle Errors (Column mapping, other?)
Hi All - We are using Data Shuttle to offload content to sharepoint for the first time, and I've made sure my headers match, etc. I've tried both CSV and EXCEL. I'm at a loss at this point, and have seen others suggest similar issues without much detail on 'resolution' - any insight is greatly appreciated. Same error, same…
-
Help Article updates January 2026
Hello Community, We’ve published new videos on these topics: Smartsheet contacts in Manage contacts in the My Smartsheet Contacts list Brandfolder user permissions in User permissions How to use Brandfolder asset automations in Brandfolder asset automation How to use Data Shuttle to upload data in Create an upload workflow…
-
New to Data Shuttle... Is there a way to set a notification when a Shuttle workflow is Complete?
Well. My title pretty much IS my question. We just got Data Shuttle and I have been playing around with it, and while I find it VERY useful, I am wondering if there is a way to notify myself when a shuttle is complete. I have thought of a few workarounds to do this. One I thought of was to have a Worksheet where I can…
-
Data Shuttle- Filter Logic For Dates include "Is in the next (days)" and "is in the last (days)"
Update the Data Shuttle Filter Logic For Dates to include "Is in the next (days)" and "is in the last (days)". The workarounds are adding too many columns to my file.
-
Uploading
Hello, My upload workflow mapping is not working properly. I have a column that won't appear for mapping. I've checked the source sheet: it's there. The source column is a symbol column and so is the destination sheet. . Any simple ideas to address this.?
-
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…