-
Data Shuttle Replace Limit of 20K
Data Shuttle currently only supports a replace limit of 5K. Please increase the replace limit to 20K.
-
Need Help Automating Copy of Historical Values
Hello, I have a sheet that shows Annual Sales Forecast data in two columns - one column for current month forecast, one column for previous month forecast. I use those columns to calculate a third column to show variance from previous to current month. The current month column is pulling values from a separate sheet that…
-
Data Shuttle - anyone else having issues logging in?
Hello - I am having issues logging in to Data Shuttle. It just keeps taking me back to the "sign in with Smartsheet" page: Even though I'm logged in to Smartsheet and Control Center, it will NOT let me access Data Shuttle (and yes, we have access to all the apps Smartsheet has to offer). Thank you!
-
Data Shuttle to allow for the source file to be a sheet within Smartsheet
Currently Data Shuttle does not allow for the source file to be a sheet within Smartsheet. The request is to have the ability to select a sheet and not just use the attachment function as it currently is built.
-
Data Shuttle Run Options
Provide the ability to modify the Data Shuttle Run Options to specify a specific set of dates etc. much like setting up recurring meetings in outlook. Example: End the run schedule on December 31, 2023 at 11:59pm.
-
How do I import multiple excel files into one Smartsheet sheet using data shuttle?
I have approximately 30 project plans that I am trying to combine into one master project plan for a specific department. I want to do this via data shuttle so that I can set up automations for when a task is either started or completed to go directly to the project manager so they can input the actual date, as the…
-
Datashuttle offload to unique file name or append to file
I see in the existing workflow for offloads that the "action" is replace, can we either have an option to create a new dated file with the date of the execution appended to the name or can we have options to choose to append new data to the export file rather than replace it entirely I would have thought its a relatively…
-
Remove Rows That Are No Longer In Report
I've done a little bit of research and from what I'm seeing there isn't a way (but I'm hopeful you all have a workaround 😀). So I have sheets that contain multiple unique IDs for tasks (they are separated out by manager since we have so many of them) and if a task is deleted on a project plan because it isn't needed…
-
Data Shuttle and Googles Sheets that are connected by BigQuery
Hello all I wanted to use Data Shuttle to import data from Google sheets. This sheet has multiple tabs of which some are connected by BigQuery and some are not. When I use Data Shuttle and target the "connected" tabs the mapping only shows the name of the Tab itself and not the column names. But if I select a tab that is…
-
Data Shuttle expressions
Hello How can I get the total count for all entries on a weekly basis using Data Shuttle? Currently I get the total count imported to a sheet. This count is currently 26 entries and it fluctuates weekly. I would like a way that data shuttle using expressions can provide me this total count in one cell. Thanks for your help.
