-
Merged: Data Shuttle - Update dropdowns on multiple sheets
This discussion has been merged.
-
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…
-
How to prevent data shuttle from converting excel text to number
An excel xlsx sheet has some data saved as text that data shuttle is converting to number even when the workflow column type is defined specifically as text. For example '2526 in excel is coming in as 2526 (without the leading ') and causes formulas not to work. The exact same excel sheet can be imported manually (not…