-
Data shuttle upload logic use contains instead of exact match
In Data Shuttle - Select your source file: I want Attachment Name to use "contains" instead of being an exact match. Oftentimes, I receive recurring reports that have the same report name with the date the report was pulled appended at the end. This forces me to use the Most Recent Attachment option which then prevents me…
-
Auto Generated Unique ID
Hello Smart Heads! Happy New Year! I am facing an issue with big data sets, missing a single unique ID. The only option of creating an unique ID is by joining content from 3 various cells, see: id is created by using simple formula: =EntryNumber@row + BLNumber@row + ContainerNo@row In a raw file (excel of course), I have…
-
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…