-
UPDATE: Is there a way to ignore case in a unique identifier
UPDATE: I figured out something about my query below - not all of the doi's on the source and target sheets have the same case (some lower case, some upper). I think this is my issue, which presents a new problem. Is there a way tell smartsheet to ignore case? Or a formula to change case? I'm running into issues where my…
-
Help Article updates
Hello Community, We’ve added a Video Tutorials page to help you dig deeper into some areas of Smartsheet. Read on to learn more about some of the content that is now available to you. Learning tracks recently launched or updated: Data Shuttle Learning Track Resource Management Learning Track To view the full catalog of…
-
Data Shuttle Workflow errer error occurred while trying to register the webhook
Data Shuttle Workflow error occurred while trying to register the webhook. I refresh the data with an attachment so not sure what webhook this is referring to
-
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…
-
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…