-
Data Shuttle Upload Google Sheet
Team, Is there a way to use Data Shuttle to import a specific tab in a Google sheet? I know it normally had to be the first tab in the Google sheet. I have a Google sheet with multiple tabs I would like Smartsheet to import.
-
Merged: Data Shuttle -> Run Options based on Sheet Changes
This discussion has been merged.
-
Data Shuttle Ownership Transfer
Hi all! I own a large number of Data Shuttles that support an automation workflow our team owns. I will be leaving the team and am looking for a way to ensure these Data Shuttles continue executing correctly without any dependencies on my account, which will be shut down. I've found some old posts that indicate ownership…
-
Sheet Timeout & Performance Issues – Identical Copy Works Fine, Original Doesn’t
Hi everyone, I’m currently working with a Smartsheet that includes: ~30 conditional formatting rules ~1700 rows Multiple columns with INDEX/MATCH formulas Numerous columns with regular @cell formulas Numerous columns with various types of data Two Data Shuttle workflows that update dropdown values in two columns Multiple…
-
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…
-
DataTable used for a Datashuttle Workflow
Hi, I attempted to use an upload workflow (Datashuttle) for a sheet connected to DataTable, but the data did not populate. Is this a limitation within Smartsheet?
-
Automate a sql query of public information to merge with Smartsheet
Hello! I'm seeking steer on an automation. I am manually mining publicly available data (ClinicalTrials.gov) using a query of this database - https://aact.ctti-clinicaltrials.org/ - and I merge the results into my sheet via a data shuttle upon attachment to the sheet. At present, I do this about once a month (or whenever I…
-
Importing Data into existing sheet
Anyone know the benefit of using data shuttle when the only option is to import from another Smartsheet? Why cant I use it to import from Excel or CSV? I'm currently importing from excel to a Smartsheet, however each time I do this, the sheet saves with a new name and I have to go retrieve it. This is counterintuitive when…
-
How to manage large data set uploads without Data Shuttle or DataMesh when creating a SCC Blueprint?
I have a client who has a Smartsheet commercial plan and just migrated to Microsoft GCCH. I know DataMesh is not directly integrated with Smartsheet Control Center (SCC). Because the client does NOT have a Smartsheet Gov plan, they are NOT able to utilize Data Shuttle if the source is OneDrive/SharePoint. Does anyone have…
-
Dynamic drop down Data Shuttle not working
Tried both options of Data Shuttle workflows (upload and offload), but neither is working. I've followed the help article available, but it's not working. Getting stuck at the "map column" section, where it always says that column is not mapped. Any help is much appreciated.