-
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.
-
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…
-
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.
-
How can I upload Excel without losing groups and hierarchies?
My excel has rows that are indented to show groups and hierarchies. Can Data Shuttle do the upload so that I don't have to manually recreate ancestor levels?
-
Data Shuttle 'contains' filter does not return any results
I am trying to filter a column that has a list of document names. Some of the documents are 'plans' Example: Onsite First Installation Plan - v08 I want the filter to only return rows where the document name in the row has the word 'plan' in it. When I try the contains filter, Data Shuttle filters out all the rows and…
-
Data Shuttle support
Hello I currently have one main sheet used as a central repository. I have another sheet in which I have manually populated data from the main sheet. I would like to use Data Shuttle to automatically populate that data every week. Thanks
-
Best Way to Pull A Ton of Data
Hello Community, I have recently been given the challenge of pulling a ton of data from a source sheet to a target sheet, and am trying to figure out the best way to pull all the data efficiently and not run out of space too quick. Unfortunately we cannot use data mesh because each row has 7 target columns to pull from.…