-
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…
-
Data Shuttle not updating blank values from source file?
Anyone else having this issue? All the Data Shuttles that I set up, are not anymore been bringing data to Smartsheet from cells that have changed to being blank in my Source Location. This was discovered yesterday, 10/17, when I received many reports from colleagues that work on different sheets that the data shuttle…
-
Do Data Shuttle Input Expressions work to build a key column?
I have this sample dataset, I want to test Input Expressions to upload data and have it mapped to the Unique Identifier Column, which is Column7. When I run this workflow, there are no changes done nor added rows. This is the formula I used in Input Expressions (I named it Column0): ="ID: " + [Column1]@row + " ; Name: " +…
-
Data Shuttle Import Timestamp issue
I am attempting to import data from Excel with several Date & Timestamp fields. The format in the source file is: 04/16/2024 21:17 What I get in Smart Sheet upon Import: 45371.83695601851851851851851851852 I have tried leaving the destination column as text/number, I have tried setting it to Date - no dice. The default…
-
How do I get alerted when my data shuttle workflow to update drop downs failed?
Hi - I have several data shuttle workflows to update dropdowns. They all appear to be running successfully, but then I find that a mapped value is not present in the drop-down. When I go to edit the workflow I get the following error - One or more of the columns in your target sheet are out of date. Please refresh your…
-
Now Announcing - Data Shuttle Error Notifications!
Hi Community, I am beyond excited to announce a much anticipated Data Shuttle feature - workflow error notifications! As a Data Shuttle workflow owner, you will now receive in-app and email notifications for erroring workflows with links to the run log so you can see details about the error. You can learn more about Data…
-
View Data Shuttle Status on Dashboards
Is there a way to display current Data Shuttle status and the last time a workflow ran on a dashboard? I'm frequently having to check Data Shuttle to see when a workflow ran last, and it would be useful to have this available via a report, widget, or embeddable content.
-
NEW Help Article! Create dynamic dropdowns with Data Shuttle
Hi Community, Did you know that you can use Data Shuttle to create dynamic dropdowns? Dynamic dropdowns with Data Shuttle can automatically update a dropdown list in one location when that list has changed in another location. I've seen some questions around this in the Community and wanted to call out the new Help Article…
-
Control Center Advance Functionality
For Control Center to be REALLY helpful, it would be useful to be able to set up advanced functions as part of a new item being spun up. Such as creation of: WorkApps (actual WorkApps, not portfolio WorkApps DataMesh Data Shuttle Etc.
-
Error Notifications for Data Shuttle
I recently starting using Data Shuttle (awesome!) but as a beginner, I made a few changes to column names and it shut down the automated offload. When I went back into Data Shuttle I could see a large red X telling me it wasn't running and the last time it did run. I would really appreciate an email coming to me when the…