-
File upload to google docs
Hey all, New and generally overwhelmed user and Admin. We are a small consulting business with 2 staff/owners. We are tracking all financials (invoices, expenses) on the platform. We use forms to take pictures of receipts and it works beautifully. Our bookkeeper wants all of our receipts uploaded to google drive as PDF…
-
Data Shuttle dropdown menu not updating correctly according to filters
I have a drop down menu in a sheet and corresponding form that I want to automatically update using data shuttle according to todays date. I want the drop down to have selections for certain months, and then as time passes and cut-off dates are reached, those months are removed and are no longer available from the drop…
-
Data Shuttle with MS Teams
We are downloading data from our operating software, and saving it in MS Teams, with Data Shuttle pulling information into Smartsheet. It works fine, as long as the file in MS Teams is open, which is not ideal. Any suggestions on why the file in MS Teams has to be open and how do I get around that?
-
Update Dropdowns - Data Shuttle
Hi all, I have an intake sheet with all of my projects in the pipeline and I have time sheets for around 50 users. Each user can have as many projects assigned to them that they are tracking time towards (this all resides in their respective time sheets). I want the list of projects from the intake sheet to show as…
-
Troubleshoot with Data Shuttle Upload Workflow error: CANNOT_UPDATE_CELL
I am running into an issue with my upload workflow where the error message is shown below. The column type is Contact list. There are no value restrictions and allow for multiple contacts. I have other Contact list columns mapped in the same upload workflow that worked fine with the upload workflow. Hoping someone can…
-
Data Shuttle Symbols - ​
Hi, I am offloading a sheet into excel to just build out a timeline for my team using a scatter chart. Smartsheets Timeline tool just doesn't quite do what I need yet. After I used Data Shuttle to offload the data a few of my titles came through with "​" in the title name. Any guesses as to why and how to fix it? There…
-
Data Shuttle
I am using data shuttle to upload a large spreadsheet to Smartsheet. The data shuttle program quit recognizing the first cell in my spreadsheet and I cannot determine why. I have tried changing this cell to both a text format and a number format and it still does not recognize the cell. I have remapped and refreshed…
-
Grouped Filters in DataShuttle
The ability to use grouped filters in DataShuttle would significantly increase the flexibility and usability of the import dialogue. Example: (1 AND 2) OR (3 AND 4). This would allow for more criteria to be added to the import filter to get more targeted data added to a sheet.
-
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…