-
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…
-
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…
-
Data Shuttle filter for dates after a certain date?
I'm trying to pull data from an Excel report into Smartsheet. I cannot change the parameters of the Excel report, but I only need rows that have been updated after a specific date to merge into Smartsheet. I tried adding a filter that is greater than the date, which works in reports, but Data Shuttle is still pulling in…
-
Input expression in Data Shuttle to create a unique identifier?
Hi all! I've been trying to figure out the use of expressions in Data Shuttle but haven't been able to figure it out, so I'm hoping someone here will be able to help. I have a sheet set up with a Data Shuttle workflow which pulls data from a report in Excel. In order to get a unique identifier, I need to combine the data…