-
Offloading Data to One Drive using Data Shuttle
Hi everyone, I am trying to offload a Smartsheet sheet to OneDrive. When I sign in from the "Select your target file" page after selecting "OneDrive & Sharepoint" as my target location, a notification appears that I "Need admin approval". I have contacted my IT team to grant me the approval but they are telling me that a…
-
Data Shuttle Mapping
I am creating a data shuffle workflow with a source that has 74 columns. Is there a way for the headers to auto populate when I am mapping, or do I manually have to type in my headers for all columns?
-
The Data Shuttles aren't processing on upload but I can run manually. Any ideas why?
I have about 100 Data Shuttle workflows which have been running as expected on upload for the past 6 months. On 11/13 all of sudden about 100 decided to stop running on upload. I can still manually run them. The offload workflows are working so that should trigger them to run.
-
Data Shuttles aren't processing on upload
I can process them by clicking RUN, but they won't process on upload. Any ideas on why?
-
Data Shuttle Offload--Where is the data ?
Hello- I have created an offload workflow in data shuttle-from one smartsheet to another, but once the workflow says complete I can not find the new rows. When I look in the sheet history of the target sheet it shows that an attachment was succesfully added. Does anyone have any experience with this issue?
-
Can Data Shuttle avoid overwriting existing cells that meet a current criteria in Smartsheet?
I am uploading a status from another system. The other system may contain information not yet available in Smartsheet, but Smartsheet remains the most current version. If an item is marked as "Complete" in Smartsheet, I'd like it to remain "Complete" and not be overwritten by the Data Shuttle. I see there are filters for…
-
Enhancement to update Data Shuttle to recognize/preserve leading zeros in front of numbers
Use case: Managing hundreds of cloud accounts that have a fixed length ID and a randomly assigned number. Some account IDs have 1-3 leading zeros, some have none, as long as the overall length is 12 digits. Issue: When using Data Shuttle to import updated lists of accounts, existing accounts with leading zeros, are deleted…
-
Sheet Access Report Size Limitations
Hello Community Friends - Does anyone have a creative solution for managing the Sheet Access Report? Ours has exceeded the max row limitations of both Excel and Google Sheets. We need the ability to look up who is Sheet Owner and/or Admin of various sheets that we might not have access to, but we can no longer load all of…
-
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…
