-
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…
-
Data Shuttle Run Options - on specific date or day of month
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.
-
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?
-
Dynamic contact list using reference sheets and Data Shuttle
I have several sheets (>20) that utilize a contact field for which I need to update the options whenever there are changes to our roster. I have difficult contact fields depending on someone's role in the department. My solution, based on suggestions here, is using a regular dropdown as my "contact" field that users…
-
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 - - 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 think about it). I would like to…
-
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…
-
Data Shuttle flows not running
I tried making a few data shuttle upload workflows. The intent was to have any updated data on an excel file in onedrive, sync back and update in smartsheet. I properly mapped my columns and have a unique id that matches in both datasets. I set these to a manual run instead of a schedule. When I hit 'run' it spins for a…
-
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.
-
Data Shuttle and Images
Hello Smartsheet World! Has anyone found a solution to using Data Shuttle to import images? I am currently using a connection to an excel file on a SharePoint site that contains images. I would like to include these in my Smartsheet's but have only been able to manually associate images. This is not feasible as our Product…