- Data Shuttle Update Rows Workflow: Preventing Duplicate Updates
Hi all, I have a data shuttle update workflow that runs on a schedule updating rows in the target Smartsheet as they change in an excel source file stored in Box. I wanted to see if there was a way to somehow configure the data shuttle workflow so once a row has been updated, it can't be changed again. I tried doing this…
- 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…
- How to push data into Data Table via API?
Hello, Is there an API to push data into Data Table in Smartsheet? We have a client using Smartsheet and we are able to push data into sheets using the SDK. However we have been asked to feed them into Data Table directly. I can't see anything in the API documentation related to Data Tables. Is it even possible? I read…
- 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…
- Share Data Shuttle Workflows
We are fortunate to have multiple Data Shuttle gurus in our organization, but it has become difficult to track who owns the workflows that manage different dropdowns and sheet rows. It would be fantastic if there were ways for all users to easily identify what dropdowns/rows are being updated via Data Shuttle workflows,…
- Data Shuttle Workflow Triggered by a Workflow
With the various amounts of ideas in the community and potential implementations already in progress, who knows if this idea might become redundant at some point. But from what I've seen so far this doesn't seem to exist just yet. I think being able to trigger a Workflow in Data Shuttle based on the execution of another…
- 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.
- 航天飞机数据错误”指定的关键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…