-
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.
-
Allow Data Shuttle to use reports to offload data
Hi, I have a Dynamic report that gathers information from the same sheet across a number of projects and displays the lines that meet a certain filter criteria. Currently I have to export this to an excel file and add it as an attachment to the sheet that I want updated by the Data shuttle workflow. It would be good to…
-
Not able to connect source file through Data Shuttle
Hello Team, I am trying to connect a source sheet my workflow via Data shuttle. Selecting "Smartsheet Attachment" as an option. But for some reasons, the file is not appearing in the attachment name I am entering. I tried Sheet ID and Sheet Link too
-
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…