-
Best Practice: Importing and Replacing Large Amounts of Data on a Weekly Cadence
Hello, fellow Smarthseet Gurus! I need some best practice advice. On a weekly cadence, I have a vendor that supplies me with a "data dump" status report containing more than 2,500 line items. I need to get this report uploaded, on the same cadence, into Smartsheet with the least amount of work possible, preferably as…
-
Data Shuttle Not Mapping Certain Columns
Hey All, I'm working on a Data shuttle project, and for some reason it's not mapping a couple of columns on the upload workflow. The columns in question are: Block Row Number The offload workflow seems to work fine, as it shows up in the Excel file it creates, but I can't get them to work in an upload work flow.
-
Data Shuttle - Track Changes Difference from Previous Upload
Hello, I am using data shuttle to upload data daily. I have track changes on to see the changes that were applied. However, how can I see what the difference was? Day 1: 100 Day 2: 102 The difference is 2...but how to see what the change is in a separate column?
-
Data Shuttle - duplicate datas ?
Hi, I did some tests and I think I know the answer but I still want to be sure. I have a Smartsheet which is a catalog of trainings, and then a database with each row corresponding to an employee + a training. I would like to avoid formulas in my database, and I was thinking to use Data shuttle to offload the datas from…
-
Data shuttle offload to Google Sheets
Hi can you please add file type google sheets to the offload file along with the existing excel and CSV. Many Thanks Shaun
-
Activity Log Should Always Have Data
The sheet activity log shows a row was deleted but it does not show the deleted data if it was deleted using an external application like Data Shuttle. This should be fixed.
-
Export comments in a separate workbook tab with Data Shuttle
Hi All, I'm using Data Shuttle to offload a Smartsheet for further refinement and analysis. When I normally export the Smartsheet into an Excel File, it includes the comments on the rows as a separate workbook tab, but when offloading the Smartsheet into a file via an automated process, the comments are lost. It would be…
-
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
