-
I need Data Shuttle to work with Trailing Zeroes
This is a huge pain point for me. I often have Data Shuttle lookup values that end in a zero (like 6457813.54610). When I set up a data shuttle, the rows that have a trailing zero don't pull back match when the Data Shuttle runs. I REALLY don't want to have to write a function that says: look for the "." and if the count…
-
Data Shuttle Price and features
Hi. Can someone tell me the monthly subscription fee of Data Shuttle please? The only feature I expect to accomplish with Data Shuttle, is to auto-update the dropdown column values, by linking the given dropdown column to another column / sheet of Smartsheet. By this I mean I will not be importing data from any external…
-
Getting Data Shuttle to recognize a column as number/text, not checkbox
I'm in a pickle. I set up a Data Shuttle that imports a CSV, but the target sheet recognizes 0s as a checkbox. I need it to recognize the 0 for the formula. When I try to change the column type (Actual Work in the screenshot) from Auto to Number, it won't give me that option. Changing the column type in the source sheet…
-
Data Shuttle not deleting rows
Hi all, Im new to data shuttle, implementing my first workflow.. overall its working fine, but what its not doing is deleting records when I attach new data to my source sheet. The scenario is, the source sheet contains a row thats not in the updated data. My expectation is when data shuttle runs it finds a target row…
-
Simple Data Shuttle filter question
I'm embarrassed to ask this, but how do I set up the simplest filter within a Data Shuttle workflow? There's one column - titled Onsite or Web - where I only want to pull rows with Web. What would I put for the filter? I've tried (1) where Onsite or Web equals Web. I've tried every other combination. It doesn't end up…
-
When I upload a smaller file to my Data Table will it remove the old data if it exceeds the new?
Hello,, I'm figuring out data tables slowly and a question I have is if i upload a csv with 200k rows to my data table, then i turn around and upload the same file but it only has 150k rows, will it delete the extra 50k? thanks, Spencer
-
Data Shuttle Offloading Wrong Data?
Hello, I have a main data source which collects project information from different vendors. Figure 1. Example of main sheet row To work with outside vendors, we have public facing sheets that we offload data to using data shuttle. Figure 2. Data Shuttle Offload Criteria This data is then uploaded to the company's sheet…
-
Data shuttles
If I am not planning to share a file in another platform, why would I need to "off-load" data from a smartsheet file? Must "off-load" be used to pull the data into another smartsheet?
-
Data Shuttle - Adding New Records
Hi all - I have a Data Shuttle process that runs when a new attachment is added. The goal of the process is to add all records in the attachment to the sheet, but I'm struggling b/c I need to map a Unique Column according to Data Shuttle for the Destination Sheet. The process fails to load all of the sheet rows because…
-
what is the best way to bring in something from another sheet but without using parent/child
What is the best way to bring over the revenue budget for a specific employee? there's two rows for each employee since each one is for a specific project. the revenue budget lives on another sheet. I don't want to add hierarchies to this sheet since I'm using it for data shuttle.