-
Data Shuttle Expression Not Working
Hello, I'm trying to create a Unique ID using an expression in Data Shuttle that looks at three columns. First, if there is a value in column A, then use that, if not use column B to create the first value (Value 1). Then I'm checking in column C to see this there's a value (Value 2). Then, I create the Unique ID, by…
-
Uploading an Excel with Data Shuttle Containing Duplicate Rows
I have a Data Upload workflow via Data Shuttle that runs on attachment for the most recent file. The excel files that stakeholders are uploading usually only have ~10 rows and when it goes through the workflow, the rows self-populate into the correct positions within a Smartsheet master database. The problem I have…
-
Reupload Data with DataShuttle
Dear All! I would like to create a tool which uses Data Shuttle. Basic idea is to ask user to upload attachment (via a form) which would trigger a data shuttle and info in the attachment would go to a transition sheet from where it would be moved to the target sheet with automation. It works nicely, however, I need to…
-
Data Shuttle Error Message
I realized a few of my shuttles were completed with errors and they all have the same error message of "Unable to add rows to target sheet : UNKNOWN: The specified key does not exist." but I'm unsure how to fix this error? I tried reselecting the target sheet, but it already seemed to be looking in the correct area.
-
Data Shuttle Error "Specified Key Does Not Exist"
In Data Shuttle, I have a workflow that is producing the following error: Unable to add rows to target sheet : UNKNOWN: The specified key does not exist. (Service: S3, Status Code: 404, Request ID: 7FED8H5R7Q5AXB87) This workflow has been operating fine for months (runs twice a day) with no errors and this just started…
-
Remove formulas in data shuttle
Data shuttle does not allow formulas to be turned off so when I upload an excel file in data shuttle, my numbers are being rounded.
-
Windows Template Folders
Is there a way, via Control Center or other, to duplicate a Windows template set of folders for a new project when it is created in Control Center? We need this for all the work that is going on in a project (that is not in Smartsheet).
-
Workflow or Data Shuttle for PowerPoint Document Upload
I've done some research to see how I can have a PowerPoint file automatically uploaded to Smartsheet either via a workflow or via the data shuttle. It appears that PowerPoint isn't a supported file type and figured I'd post here to see if anyone else got this to work somehow. Thank you!
-
Data Shuttle or other solution?
Hello, I am trying to figure out the best solution to a project. Basically, we have a system outside of Smartsheet that will not connect to Smartsheet (old system) and we do not want to pay to integrate them. I want to manually upload exports from the legacy system (.CSV files) into a preformatted Smartsheet sheet on a…