-
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.
-
GOV Data Shuttle Sharepoint Target Sheet Option
I'm trying to offload data from Smart Sheet GOV to sharepoint, however in the target sheet option for data shuttle it only gives me the option to offload as smart sheet attachment. Why is this? How can I get the option for sharepoint or One Drive.
-
Data Shuttle Ownership Transfer
Hi all! I own a large number of Data Shuttles that support an automation workflow our team owns. I will be leaving the team and am looking for a way to ensure these Data Shuttles continue executing correctly without any dependencies on my account, which will be shut down. I've found some old posts that indicate ownership…
-
Data Shuttle Reorganization
Hi there, We have +400 data shuttles currently. 3 per project and 100s of projects. Is there a way to organize these. I was thinking of restructuring our way to shuttle data in for these sheets. Would it be possible to data shuttle into a template (parent project sheet) and redistribute somehow to to the child sheet. There…
-
Sheet Timeout & Performance Issues – Identical Copy Works Fine, Original Doesn’t
Hi everyone, I’m currently working with a Smartsheet that includes: ~30 conditional formatting rules ~1700 rows Multiple columns with INDEX/MATCH formulas Numerous columns with regular @cell formulas Numerous columns with various types of data Two Data Shuttle workflows that update dropdown values in two columns Multiple…
-
DataShuttle Error
We are using Datashuttle to move data from an excel file in SharePoint to a sheet in Smartsheet. We received an error this morning. I looked at the workflow and the excel sheet but could not find any issue. I ran the workflow again and it completed. However, it wiped all the existing data out of the smartsheet. Thoughts?
-
Dynamic contact list using reference sheets and Data Shuttle
I have several sheets (>20) that utilize a contact field for which I need to update the options whenever there are changes to our roster. I have difficult contact fields depending on someone's role in the department. My solution, based on suggestions here, is using a regular dropdown as my "contact" field that users…
-
DataTable used for a Datashuttle Workflow
Hi, I attempted to use an upload workflow (Datashuttle) for a sheet connected to DataTable, but the data did not populate. Is this a limitation within Smartsheet?
-
Automate a sql query of public information to merge with Smartsheet
Hello! I'm seeking steer on an automation. I am manually mining publicly available data (ClinicalTrials.gov) using a query of this database - - and I merge the results into my sheet via a data shuttle upon attachment to the sheet. At present, I do this about once a month (or whenever I think about it). I would like to…
-
Data Shuttle flows not running
I tried making a few data shuttle upload workflows. The intent was to have any updated data on an excel file in onedrive, sync back and update in smartsheet. I properly mapped my columns and have a unique id that matches in both datasets. I set these to a manual run instead of a schedule. When I hit 'run' it spins for a…
-
Dynamic drop down Data Shuttle not working
Tried both options of Data Shuttle workflows (upload and offload), but neither is working. I've followed the help article available, but it's not working. Getting stuck at the "map column" section, where it always says that column is not mapped. Any help is much appreciated.
-
Data Shuttle and Images
Hello Smartsheet World! Has anyone found a solution to using Data Shuttle to import images? I am currently using a connection to an excel file on a SharePoint site that contains images. I would like to include these in my Smartsheet's but have only been able to manually associate images. This is not feasible as our Product…