-
Data Shuttle - Excel File Not Connection/Mapping Not Working
Hi all, I have an Excel file in a shared folder on SharePoint that I want to upload to Data Shuttle. For some reason, the table does not want to map. I know I have the correct tab and row numbers selected, but I'm still not seeing a Unique Identifier dropdown, just "Please select a Source in order to see dropdown options."…
-
Bi-directional update between 2 sheets without report?
Hi, is there any workaround that allows for bi-directional updates between two sheets without the use of a report? For example, Sheet 1 has Unique ID and Status columns, same goes for Sheet 2. What I want to be able to do is if either the Status column gets updated for a project in Sheet 1 or Sheet 2, the information will…
-
Importing Emails of Users, Smartsheet Not Converting to Contact First and Last Name
Hello! Has anyone figured out a way to load a column of emails or names, any combination really, into a contact column on a sheet where the user's first and last name appears rather than just the user's email? We're working on a large list that will be a source table for numerous systems and I want to user's contact to…
-
Is there an automation that can be set up to run a Data Shuttle workflow when a row is added to grid
I am trying to see if there is an automation that would run when a row is added to a grid, it would trigger a particular Data Shuttle to run on. Basic over view is I have created a visitor check in. I have a Data Shuttle (Off Load) run every 15 mins were it takes the names of the visitors and puts it in a attach excel…
-
Data Shuttle Date and Timestamp Issue
Hi, I'm running into an issue as described in this post, but with Data Shuttle: Timestamps only match selected date format when clicked on — Smartsheet Community I configured a Data Shuttle workflow to replace all rows when a .csv file is attached to the target sheet. The attachment has a Timestamp column with a Date and…
-
Data Shuttle: update a checkbox in the source sheet to indicate success
Currently, Data Shuttle efficiently migrates data from Smartsheet to SharePoint, OneDrive, GoogleDrive, Box, & as a Smartsheet Attachment. This Providing a seamless integration between the two platforms. However, one aspect that could enhance user experience and workflow efficiency is the ability for Data Shuttle to…
-
Data Shuttle Execution Duration
I'm looking for information on how long your Data Shuttles run. I have one offload, and one upload (first ones - very small - under 50 rows added no deleted, skipped, filtered, no drop downs updated) Looking at a month's worth of logs I see a noticeable increase in execution duration for no apparent reason. What have you…
-
Separating Table by Week
Hello, I am working on a project where I am pulling in employee utilization totals from sheets being populated by data shuttle on a bi-weekly basis to a table that calculates totals. The cloumns are basically using SUMIFs to populate the totals but I'm running into an issue where I can't separate these totals by week. I…
-
Bridge and DataShuttle
I have a sheet that is attached to a DataShuttle that is used to upload an invoice. On the invoice there could be multiple line items per category and there are 19 categories. I want to use bridge to automatically sort the entries that get added into their respective parent rows. I have been able to do this with one or two…
-
Data Shuttle Error 400
Does anyone have experience unlocking the Google Drive authorization error when trying Sheet Export or Data Shuttle offload? Our Google security team believes they have "unlocked" Google Access because we are now able to attach files from Google Drive to a sheet, but when trying to offload or export we are faced with this…
