-
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.
-
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…
-
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…
-
Data Shuttle - Update dropdowns on multiple sheets
I have multiple sheets where I update the dropdowns all based on the same information. It would be great if I could create a single Data Shuttle job that would update all of these sheets at the same time. Having to create dozens of jobs to do the exact same thing, just to a different sheet, is burdensome and confusing to…
-
Data shuttle - how to update with recurring reference column
I have a 1000 or so lines in my sheet. I need to update a set of contacts so I've set up a data upload but it only changes the data for the first instance of my reference column. Example Family Members Flintstones Fred, Wilma, Pebbles, Barney, Betty, Bam Bam (my favourite) Muppets Kermit, Ralf, Animal, Beaker, Swedish…
-
Data Shuttle to automate identification of differences between two excel sheets with > 10,000 rows
Can it be done? Data Shuttle to automate identification of differences between two excel sheets (one column in particular) with over 10,000 rows. Basically what the title says. I want to automate a process and was pointed in the direction of Data Shuttle to accomplish this. I have a regularly reoccurring excel sheet that,…
-
Data Shuttle - don't delete certain rows
Hello - I have a sheet that tracks current projects for all employees, we also track their time off requests here and turn it into a Gantt chart and use it as a workload tracker. I'd like to create a Data shuttle so I can drop updates to the projects into the sheet (new projects, remove completed projects, updates, etc).…
-
NEW: Power BI Connector for SmartSheet – Built into 𝘿𝙖𝙞𝙡𝙮 𝙒𝙤𝙧𝙠 𝙈𝙖𝙣𝙖𝙜𝙚𝙧
We’re excited to share a breakthrough we’ve built as part of the 𝘿𝙖𝙞𝙡𝙮 𝙒𝙤𝙧𝙠 𝙈𝙖𝙣𝙖𝙜𝙚𝙧 👉 ➝ a direct connector that syncs Power BI data into SmartSheet, live and fully structured. 🔄 No more manual exports. No more column prep. No more missed context. With our connector, Power BI becomes the source of truth for your Smartsheet…
-
Data Shuttle does not show Add Transformation rules in workflow creation
Hi everybody, I am trying to create a new workflow using Data Shuttle to import data from an Excel SS. Several of my columns in Excel are integers, while in SS I have them as Yes, No or Hold, and some could be True/False. ChatGPT tells me to add a transformation rules: score greater than or equal to 1, set value to Yes,…
-
Data Shuttle Not Saving Smartsheets
I have been using Data Shuttle for years, using the same Smartsheets and workflows. Suddenly (looks like just since May 1st) my dashboard, which is my end product, is not updating. Here is the way the workflow works: I attach an excel spreadsheet attachment to Smartsheet #1. Data Shuttle #1 merges data from source sheet…