-
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…
-
Please Allow Multiple Admins for DataMesh
Our team is really struggling to troubleshoot issue when the owner of a DataMesh or Data Shuttle is out of the office. Please allow multiple Admins and/or Editors (or, at the very least, Viewers) for these critical tools.
-
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 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.