-
Data Shuttle converting mmm d, yyyy date format to numerical value
Hello Everyone, I have a Data Shuttle workflow that has been run virtually every business day for over a year. When running today, four columns of dates converted to numerical values. No formatting of the source sheet has changed (Excel file with a Custom category of mmm d,yyyy Cell history confirms date format used to be…
-
Data Shuttle Execution Duration
I'm looking for information on how long your Data Shuttles run. I have one offload, and one upload (first ones - very small - under 50 rows added no deleted, skipped, filtered, no drop downs updated) Looking at a month's worth of logs I see a noticeable increase in execution duration for no apparent reason. What have you…
-
Separating Table by Week
Hello, I am working on a project where I am pulling in employee utilization totals from sheets being populated by data shuttle on a bi-weekly basis to a table that calculates totals. The cloumns are basically using SUMIFs to populate the totals but I'm running into an issue where I can't separate these totals by week. I…
-
Bridge and DataShuttle
I have a sheet that is attached to a DataShuttle that is used to upload an invoice. On the invoice there could be multiple line items per category and there are 19 categories. I want to use bridge to automatically sort the entries that get added into their respective parent rows. I have been able to do this with one or two…
-
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…