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