-
Data Shuttle Running 5 Hours Early
Based on the log, all my nightly Data Shuttle workflows ran 5 hours earlier than they should have last night. (This may have been happening for a while and I just didn't have reason to notice.) Example: scheduled for 1900 hours, ran at 1400 hours. That's kind of a problem since the data for the day isn't all taken care of…
-
Dynamic Dropdown - Data Shutttle
I want to create a dynamic dropdown in a sheet. The data for my dropdown reside in 6 different sheets, so I thought it would be smart to consolidate using the report function. Now the data are in a report. How can I create a dynamic dropdown with the data source being in the report rather than in a sheet? I cannot select…
-
Data Shuttle: Multiple Email and Text Filtering
Hi! I am trying to filter my offload with "does not contain" and then have a string of emails I want to omit from my contacts column. We have contacts that we are not doing the billing for so I want to exclude them. I've tried separating emails with a comma, with quotes, with <> between the email addresses and its not…
-
Data Shuttle Failing to Delete Rows on various workflows
Hi there, Not sure if this is a known issue this is being worked on? In Data Shuttle, I am using the workflow action "Replace all Target sheet rows with the data from the input file" and on multiple occasions I've had multiple data shuttle work flows give me this error - "Failed to delete (xxx) rows. Please review your…
-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
-
How to push data into Data Table via API?
Hello, Is there an API to push data into Data Table in Smartsheet? We have a client using Smartsheet and we are able to push data into sheets using the SDK. However we have been asked to feed them into Data Table directly. I can't see anything in the API documentation related to Data Tables. Is it even possible? I read…
-
Data Shuttle SharePoint Formatting
I was recently advised by the support team that it is not possible to lock formatting on the destination sheet in SharePoint which defeats the purpose of having this as every time the job runs it clear out the formatting and spacing of columns in SharePoint. Ideally, the data shuttle would only update the data points…
-
Changes to Data Shuttle Replace Mode Workflows
Hi Community, To improve sheet and Data Shuttle performance, we are changing how Data Shuttle “replace mode” upload workflows function. Instead of completely deleting and replacing all rows on a sheet, replace mode workflows will now: Scan the source data until it detects a change in the data set. From that row onwards,…
-
Data Shuttle Folders
Currently all Data Shuttles appear in one list, you can view Offloads and Uploads separately. Finding a Data Shuttle you want to Run, view and update can be very time consuming if you have a lot of Data Shuttle workflows. Being able to put them into separate folders would be beneficial, this would also be of benefit in…
-
Merged: Implementation of Data Shuttle-Workflow Folders for Enhanced Grouping
This discussion has been merged.
