-
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…
-
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,…
-
Merged: Implementation of Data Shuttle-Workflow Folders for Enhanced Grouping
This discussion has been merged.
-
Do people at smartsheet send email after we use dynamic view and data shuttle
Hi guys, I am a new user and have been tasked to test the dynamic views and data shuttle functions of smartsheet.Recently I have received a mail from someone claiming that they are from smartsheet with details about my recent use of data shuttle and dynamic view, and asked me if I want to call them to discuss my options…
-
Data Shuttle Workflow Source Filename Changes Unexpectedly
Hi all, I've created a data shuttle workflow that is about 98% of the way complete. I have data from an excel worksheet called 'EE Eval' I load to Google Drive and have the workflow set to take that file specifically and transfer its contents every Monday to my smartsheet called 'Employee Eval Tracking'. In testing, I…
-
Grid/Report Linked Cell Issue
I have a Grid I was setting up a Data Shuttle on. This Grid had one cell that was linked to a Report. After a Data Shuttle pull, the cell in the Grid that linked out was missing the previous formula and not showing the "link" symbol on the linked cell. I re-entered the formula in that cell, however when I went to the…
-
Preventing Data Shuttle workflow from overwriting locked rows
I have a process in place to pull data into a sheet, where after a cell is changed pushes out a request for approval to a manager. When Approved, we are locking the row. When Denied, we'd update the source system data, re-pull via the Data Shuttle workflow and resubmit for approval. However, we're seeing the data in the…