-
Offload Date Format
Hi, I'm using Data Shuttle to Offload a title and some dates and it is coming through with a really wonky format. Excel isn't able to auto convert this to a regular date and I tried using INT to try to make it into and integer but it returns a #VALUE! error because of the format. Is there any solution to this? This seems…
-
Data Shuttle Workflow Only Partially Uploading Data
In Data Shuttle I have an upload workflow. The source data is an excel spreadsheet with 14788 rows. The Data Shuttle upload is stopping after it adds 3832 rows and saying it is complete (no errors listed). The upload workflow does not have any filters so all the rows should be loaded. The Data Shuttle workflow has been…
-
Data Shuttle importing Values
When I use Data Shuttle to import data to a sheet, it keeps adding a ' in front of the numbers which turns them into text and not numbers. For example, $23.50 turns into '23.50 when imported through Data Shuttle. The original excel file itself is formatted correctly. Anyone know how to fix this?
-
Merged: DataShuttle Workflow Errors (Action:Replace)
This discussion has been merged.
-
Data Shuttle Issue
Looking to do a data shuttle and keep running into this prompt attached in the image. All the mapped data has unique names. This issue persists when trying to do a data upload. What would be causing this happen? Thanks
-
Data Shuttle - Unable to Map / Not Mapped
Hi there, I've been trying to set up a Data Shuttle workflow to replace all data with new attachment uploaded in another smartsheet. It was unable to map ANY columns even I try with the exact same data. It does not help either with changing any of the parameters in Data Shuttle. So the issue was that Data Shuttle will not…
-
Can I filter a contact list via Data Shuttle?
Hello! I'm interested in shuttling data from a primary sheet to secondary sheet by the contact assigned in two different columns on the primary sheet. I'd like to bring rows over where Maggie is listed as Coordinator or Back up Coordinator - 20 rows on the Primary Sheet meet this criteria when I create this filter: When I…
-
Data Shuttle Problem- No column header options
I'm trying to use data shuttle to link an excel file to a smartsheet file. The header columns on my smartsheet match with the header columns on my excel file. However, when I go to create the mapping, I don't see an option for my column header names from the excel file, it only shows: "Version". Additionally, if I deselect…
-
Data Shuttle Bulk Action Controls Now Available!
Hi Community, We’re excited to announce the addition of bulk actions to Data Shuttle to help users and System Admins better manage their workflows! You are now able to “Select All” on a page by page basis (meaning up to 100 workflows at a time) or a subset of workflows to perform the following actions within Data Shuttle:…
-
Data Shuttle doesn't seem to be importing from an Excel file when it is closed
I set up a connection with Data Shuttle to import from an Excel file stored in 'Box' cloud server. When I have the Excel file open it seems to be able to import the data correctly. But if I have the Excel file closed it doesn't seem to update any data. Does anyone know what is causing this issue?