-
Keep Search Text in Data Shuttle Workflows List
I have well over 100 Data Shuttle workflows, and they are cumbersome to work with. I appreciate the ability to search, but I've found that I have to re-enter my text in the search field over and over again as I'm moving in and out of workflows. If I click into a workflow to view something, when I return to the main…
-
Data Shuttle - Notifications if Unique ID is Missing?
Hi all! I'm setting up a data shuttle to automatically update our records when we receive inventory reports from a third party vendor who manages our warehouse. The trouble is, we've noticed that some of our items have fallen off their reports, and we need to keep an eye on this week over week. I'm trying to see if there…
-
Data Shuttle: Missing Rows/Entries
I have two workflows in DataShuttles set up to track costs on a monthly basis in a single sheet. One workflow is called "Current Month Cost" and the other is "Previous Month Cost." The sources are excel files from an external database that I have no control over. Every month, I take the previous month's excel file and run…
-
Data Shuttle Upload - Merge & Update based on key column value causing errors
Hello! I have a few Data Shuttle automations running between SharePoint / Power Automate created .xlsx files and a central repository in Smartsheet. Our key identifying point is a unique profile ID number, but we do need to use that ID number for our contractees when requesting a contract renewal. Due to this, during the…
-
Data Shuttle Issues
I get an CSV weekly with all the new hires at my company. After the new hire's start date is in the past, they drop off the list. I want to have a Data Shuttle that takes this CSV daily and updates + adds rows for every new hire. There is also about 20 columns that need to be filled out on this Smartsheet. I have tried…
-
Data Shuttle Not Updating Cells - Can Any one Assist
I have set up a data shuttle to export a list of e-mail addresses, with one other collum which is an autogenerated number which is the unique ID, this works fine. When I came to run another data shuttle to import this file into another sheet, I set up the settings, selected the unique ID to the autogenerated number collum…
-
Offload and Upload (Data Shuttle)
I was following the instructions here to automatically update dropdown values, but could not get the offload to work (as in the workflow runs successfully, but does not create a file). Thanks for your help.
-
Data Shuttle Issues
I am using Data Shuttle to export certain rows that meet certain criteria from a sheet. The goal is to have this run during a certain window of time, check where the criteria are met, put the rows into a csv file, and attach it to the same sheet as the source, replacing the old with an updated one every 15 minutes. The…
-
Hyperlink manual trigger data shuttle workflow
As of now the data shuttle workflow can only manual trigger in the data shuttle page by clicking on "Run". My idea is to allow user to trigger running a workflow by hyperlink/webhook. So user can add the link in their dashboard as a function of Button. To manual trigger the data shuttle workflow when they are reviewing the…
-
Why is my workflow not updating my Smartsheet columns after initial run?
I have set up a workflow from an excel file to my smartsheet. I have it set that whenever a new sheet is added it should update my data, but that is not happening. Ex. One of the columns is for prices. If the new source attachment has new prices and i add to the workflow, the price does not change in the Target sheet when…