-
Streamlining Production Planning: How Smartsheet Integration Saves Time and Boosts Efficiency
One of our clients faced the challenge of their planning team constantly needing to check a shared Google sheet throughout the day. The process of reviewing the data multiple times and manually updating the schedule was time-consuming and prone to errors. Missing any crucial information could potentially disrupt their…
-
Unique Identifier Column
I'm trying to get a Datashuttle migration to work and there is no documentation on the limitations of the unique identifier column. Can this column in SS be a column formula as that is how my unique IDs are being generated. I know that both of these columns exist and tested by creating a paste values column in SS in which…
-
Uploading Large Sheets In As Data Dumps
Hello, We are working on a project where we create data dumps in a folder that many sheets can use as a resource through formulas. Is there any way to upload daily under the same name, overwrite the file and not break the formulas that are pointing to these sheets? What are some solutions around this? Will we need…
-
Data Shuttle - Workflows Failing
I have multiple offload and upload workflows that have functioning quite well in Smartsheet, however after a week or two they seem to randomly not be able to find the Attachment File for the upload workflow and then give me that wonderful red error message. Anyone have a solution for this issue or at least an explanation?…
-
Automatically Export Data from a MySQL Database
Hi, I need to automatically import data from a database, which is a MySQL into Smartsheet. My admin tells me that DataIUploader wouldn't work and DataShuttle doesn't have databases as a source option? Does SmartSheet have a tool to automatically pull data from a MySQL database? Thanks in advance.
-
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…
-
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…