-
Archiving Rows
How do you go about archiving large data sets from sheets? I know you can create automations to move rows to another sheet but what happens when that sheet gets too large as well? I have thousands of entries that happen every day and I am trying to use data shuttle to offload the data but with offloads, it just replaces…
-
Counting user login between 30-89 days
The data set tracks each time a user logs in. I need metrics on users who have logged in between 30-89 days, but I only need to count the most recent instance. Also, I am using data shuttle to bring it in, so I'd like to filter out the duplicate emails keeping only the most recent instance.
-
Schedule Data Shuttle for a Specific Day of the Month
Unless I am missing something, it appears that you are unable to schedule data shuttle on a specific day of the month. I have a monthly report that comes on the 10th that needs to import into Smartsheet. It appears the only way I can make sure data shuttle catches this is to run it every single day forever. There is a lot…
-
How to use Data Shuttle to add rows without erasing changes made to target sheet?
I am using Data Shuttle to transfer a sheet of individual people activity from a source sheet to a target sheet. I want to be able to add notes to the target sheet or check boxes in columns that are on the target sheet and not the source sheet. I set up DS to merge data into the target based on a key column value. Each…
-
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…
-
Data Shuttle Folders
Currently all Data Shuttles appear in one list, you can view Offloads and Uploads separately. Finding a Data Shuttle you want to Run, view and update can be very time consuming if you have a lot of Data Shuttle workflows. Being able to put them into separate folders would be beneficial, this would also be of benefit in…
-
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…
-
Date with Time uploading in Data Shuttle comes only with Date
Hi Everyone, I'm uploading Input excel having column value "6/1/2022 1:22:23 AM". But after uploading into SmartSheet, it comes only date "2022-06-01". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P
-
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…