-
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…
-
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…
-
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…