-
Data Shuttle - Multiple Target locations
After spending a significant amount of time in Data Shuttle the last few months, it would be a great enhancement to be able to export/import files to multiple target locations. For example, I have a few sheets that 'refresh' customer data (ie. looking for new Customers, SKU etc..) weekly to add-on to the existing reports…
-
Merged: Data Shuttle - Update dropdowns on multiple sheets
This discussion has been merged.
-
Merged: Data Shuttle: Export to Multiple Smartsheets
This discussion has been merged.
-
Data Shuttle Workflow Triggered by a Workflow
With the various amounts of ideas in the community and potential implementations already in progress, who knows if this idea might become redundant at some point. But from what I've seen so far this doesn't seem to exist just yet. I think being able to trigger a Workflow in Data Shuttle based on the execution of another…
-
Schedule Data Shuttle for a Specific Day of the Month
Unless I am missing something, it appears that you are unable to schedule data shuttle on a specific day of the month. I have a monthly report that comes on the 10th that needs to import into Smartsheet. It appears the only way I can make sure data shuttle catches this is to run it every single day forever. There is a lot…
-
Data Shuttle will not find columns in source file
I am trying to setup an upload workflow where I bring data from an excel spreadsheet into a sheet in Smartsheet. The Data Shuttle workflow will not find the columns in my source sheet. The column headers start on row 2 in my excel sheet but the mapping portion of the workflow builder will not find the columns. Any…
-
Data Shuttle is not finding all columns in the source sheet
I am trying to use data shuttle to upload data from an excel file in SharePoint but when I get to the mapping part, the column names are completely different from the source. Almost as if it is not pulling the data from the sheet I specified, but a different one. I am using the second tab of the excel sheet and some of the…
-
Data shuttle upload error to client sheet with a locked store id column
Seeing if anyone has a similar experience or guidance. We have two sheets which we are using data shuttle between: • Client project tracker • Internal project tracker We have setup matching column names and types, which we want to use data shuttle to communicate updates between our two sheets. We pull unique store numbers,…
-
Data Shuttle Data And Automation
Hello, I’m running into an issue where Automations aren’t running in a workspace I created. The workspace is in Table View and uses a Data Shuttle to bring in information from a Google Sheet containing form submission data. The first three columns of the workspace are not linked to any Data Shuttle data, while the…
-
My number format/layout doesn't hold when I do a Data Shuttle offload - how do I change this?
I am trying to figure out how to make it to where my number columns don't change when I offload. I have attached screenshots of what happens when it offloads. I am not able to edit the excel file that it creates. And my column is properly formatted in smartsheet. What is a good way to avoid this?