-
Sheet Historian - grab snapshots of a sheet and append them to a Data Table
I'd like to be able to grab copies of a sheet and append them to rows in a datatable so I can build a "historian" over time. This is the use case: I have a sheet that all our project managers use to capture the Cost To Complete (CTC) for all our projects. Each week the PMs are asked to update this sheet with their current…
-
Data shuttle is not running on time
Hello, We have multiple data shuttles setup to run at 5:00 am UTC and to repeat every 15 minutes with an end time of 4:00 am UTC. We effectively need these shuttles to be running every 15 minutes nonstop. For whatever reason the shuttles will stop running for no apparent reason and will not restart without us manually…
-
Merged: Shared Data shuttle workflow
This discussion has been merged.
-
Data Shuttle Only Deleting Rows
Hello, When running an upload workflow earlier today one of my workflows only deleted rows and did not add any new ones. I had to rerun the workflow in order to get the sheet populated with data. This caused an issue as there is a pivot ran on the sheet and as there was no data it reset all of the manually input data into…
-
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…
