-
Data Shuttle Error 400
Does anyone have experience unlocking the Google Drive authorization error when trying Sheet Export or Data Shuttle offload? Our Google security team believes they have "unlocked" Google Access because we are now able to attach files from Google Drive to a sheet, but when trying to offload or export we are faced with this…
-
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…