-
Data Shuttle Works upon set up then fails
Hello, I set up an Offload workflow to SharePoint. It ran for two days and has been falling since. I receive the following error "Workflow Execute: Could not access target. Please check your workflow configuration for errors.". In some of the research, found that I should not use Microsoft Edge. I deleted my workflow and…
-
Large Data Set Solution
Hello, I have created a table to view weekly data displaying how many cases are worked vs hours worked. This table is using several SUMIFS fuctions to pull from 3 separate source sheets. My issue is these source sheets are updated every 2 weeks with roughly 2,500 rows each. So far, I have only done weeks 3-6, skipping the…
-
Insights: Ability to export Data Shuttle owners to a csv file
Hello! As a Smartsheet admin for my organization I'm being asked to identify all active Data Shuttle owners. I really like how Insights allows me to see the total number of Data Shuttle workflows and owner count across my organization. When I directly view Data Shuttle for my organization, I'm able to see all of the…
-
Problem with automation from a contact list
Hello, I'm having an issue importing email addresses from dataShuttle to a contact list, and using automation from this column. When I set up the automation triggers, it won't send to the emails in the contact list column, because it is saying it is a comment and there is an @email@org.com (just general example of what the…
-
Excel drop down menu not being uploaded when using data shuttle
I have an Excel sheet that is used by accounts receivable for tracking project payments. (Small job shop manufacturer) We do over 30 projects a year and each project is unique. There are basic payment terms but usually there are multiple change orders and special terms worked out. Here is my issue, on this excel sheet each…
-
Can Non Licensed Users Trigger a Data Shuttle Workflow?
Can a non licensed user who is shared as an editor or admin trigger a workflow for Data Shuttle upload when a sheet is added? We have a sheet that was created by a license user and has created a data shuttle upload workflow on the sheet based on latest attachment. Is it possible for a non-licensed user who is shared to the…
-
How to input data into target sheet from a source without a unique ID
For context, I am mining public clinicaltrials.gov records to associate unique trial records with results publications. There are often multiple results publications linked to an individual trial record. I have a sheet of my institutional records, each record has its own row and is uniquely identified by a national…
-
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 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…
