-
Saved changes and updates from Dynamic View are not saved in source sheet
I have some team members assigned to projects via Dynamic view, and everytime they go to edit and save their changes, it temporarily saves them, then when we go to look at the reflected changes in the source sheet they disappear. Functionality was working for a couple months, but just this week multiple team members have…
-
Data Shuttle Error Message
This data shuttle started receiving this error message recently and I'm not sure what it means. Nothing was changed on the sheet except for 3 additional text fields were added and those are set up properly with the right column properties. I checked all other column properties and those also seem to be fine. Also do not…
-
Data Shuttle Features should be native to Smartsheet
Making certain features such as not being able to upload data into an existing sheet is a serious flaw in the foundational system and making it a premium paid add-on to get this feature that users have repeatedly requested isn't a great business model.
-
Data Shuttle Upload Filters
I am using Data Shuttle to upload Smartsheet's own Users.csv report into a sheet. That report has multiple TRUE/FALSE columns. I was trying to apply a filter to one of these columns. In my target sheet all of these Booleans are configured as checkbox columns, and all columns are mapped. It took me about 15 attempts to get…
-
Troubleshooting Data Shuttle
I am having issues with Data Shuttle adding rows at the bottom. It seems to be skipping 20+ rows in Smartsheet when my data source doesn't have those blank rows. I did add a filter to filter out blank rows. Any suggestions?
-
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…
