-
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.
-
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…
-
How to use a smartsheet to update the form dropdown values in another smartsheet?
I have a smartsheet that contains employee names and employee IDs. I would like to use the employee names stored in this sheet to update a form dropdown list of employee names on a separate smartsheet that tracks employee activity. I was going to use data shuttle, however there is not an upload data from a smartsheet…
-
Data Shuttle isn't updating
Is anyone else having problems? I have tried saving the xlsx file differently, tried using a different field as a unique identifier, etc. My sheet doesn't update, and I know there are changes in the excel file! Nothing is locked and all the columns are text/number.
-
Copy few cells from 1 sheet to another based on a filter
I have a sheet named "T1 SQDVP", and I want to copy the "Safety Details" data from this sheet into the "Action Log" sheet, creating a new action under the "Follow Up Action" column. Based on the filter when Column "Safety Action / Escalation" is selected as "Action Required at Tier 1" See screenshots. Any suggestions would…