-
DataShuttle, DataMesh, Something Different--what's best
There is an excel report we get from another system that needs to be brought into SmartSheet on a weekly cadence. It is a timeline-driven document so we need the updates on dates, status, and new entries (rows) to be brought into SmartSheet. The report has this information for four teams, so we need the information from…
-
Mirroring Smartsheet
Good morning! We have a master smartsheet with employee info that we would want to mirror so we can have some of the employee info on different sheets that we can use for different tasks. Currently want to mirror employee number, name, work area from master to a new one. I tried to use data shuttle offload from the master,…
-
Importing or updating one grid from another in Smartsheet
Hi, I need 2 sheet talking to each other and help update one sheet from another as per preference. Any help is appreciated, i tried Data Shuttle but it is not giving me option of Smartsheet grid?
-
Archiving Data
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…
-
Avoiding Overbooking using Smartsheet Calendar/DataShuttle
Hello! I am trying to create a booking system for a room with multiple stations. Stations: 1 - 5. Time slots: Morning, Afternoon, All Day So far I have a dashboard with a calendar/form and separate sheet for the form submissions. With the calendar, people are able to see other bookings, but ideally, I want to use…
-
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.
-
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…
-
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
