-
Data Shuttle "Source field" not listing columns from Source sheet
Hello experts! I'm attempting to create an Upload workflow in Data Shuttle, however when I get to the step to map the fields between my Source and my Sheet, the "Source field" columns that are shown are not from my Source (saved to a OneDrive, with all of my Data Shuttle files. Below are my selections: I have verified that…
-
Data Shuttle upload using CSV files on a Google Drive
Hi, I hope someone can tell me what I'm doing wrong. I'm trying to use Data Shuttle to upload data from CSV files stored in a Google Drive folder. The CSV files are updated by batch jobs which do NOT change the filename or the file ID. Data Shuttle shows the workflows completing successfully (green check next to the…
-
Data Shuttle Export Excel File
I've created a destination file using Data Shuttle and I'm trying to generate a pivot table in the destination excel file. For some reason, the numbers in the export file can't be summed in excel. I've tried to change the format of the cells in the destination file, but that doesn't help. Thanks for your help.
-
DataShuttle Intake
I have a DataShuttle workflow where users attach a spreadsheet to an intake sheet. Question1: If multiple spreadsheets are attached to the intake sheet (via a form) does the DataShuttle workflow queue up these attachment imports? Question2: If you have to attach a spreadsheet and wait until the workflow completes, how does…
-
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…