-
How do you get a data shuttle filter to work on a column with a formula?
I'm trying to set up a data shuttle to filter out any studios that do not have "Send Survey?" checked. I've tried using "Send Survey? equals 1" and "Send Survey? equals True" and both don't work. Any help is appreciated!
-
How to create a single notification when Data Shuttle workflow is run by schedule?
Hello! I created a notification triggered by "complete" status of a column, but the sheet is is fed by Data Shuttle workflow that is set to run every 15 minutes. As a result, I received a notification every time the sheet was updated based on the workflow frequency. I need to create a single notification, when the column…
-
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,…
