-
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, 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…