-
Simultaneous Update of Project and Review Sheets, for Non-Existent Projects, with one form
I am part of a Solution Architecture department that uses Smartsheet to track project reviews. Our workflow involves two Smartsheet sheets: a Master sheet for basic project information (project name, ID, contacts, status), and a Review sheet for detailed review data (review ID, review name, review type, project name, and…
-
Merged: Data Shuttle Ownership Transfer
This discussion has been merged.
-
Data Shuttle changing the format of imported rows
I am data shuttling an excel spreadsheet .xlsx when adding any new data it is changing the format of the field. The entry in the field should look like 2019 when new data is shuttled over it changes this to 2019.00. The format of the rows in the excel are number and no decimal places. Does anyone have any ideas
-
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.
