-
Need to Create Separate Opens List from Data Sheet
Summary: I have a data sheet with a primary column listing different equipment items. Going across, there are a number of columns, 15 of which have drop downs with options N, N/A, Y, and Open Item... I need to populate a list, to a different sheet, showing only the columns, where that piece of equipment shows, Open Item.…
-
Large Data Set Solution
Hello, I have created a table to view weekly data displaying how many cases are worked vs hours worked. This table is using several SUMIFS fuctions to pull from 3 separate source sheets. My issue is these source sheets are updated every 2 weeks with roughly 2,500 rows each. So far, I have only done weeks 3-6, skipping the…
-
Sheet setup for scalable data
Looking for a best practice to set up a scalable (target vs. actual, month-over-month) sheet - There are 15 specific varying metrics (e.g. numbers, $, %) collected monthly by different people. Each metric will require both actuals for the prior month and a target for the next month. I would like to show both monthly…
-
Data Shuttle to DataTable: Replace DataTable
I want to create an automated system that maintains my DataTable as an exact replica of a source file. Data Shuttle does not quite do this for a DataTable workflow. In the Data Shuttle workflow for DataTables you can only Add and/or Update data. This can result in rows of data remaining in the DataTable when they are no…
-
Connection between Data Table and Control Center
I have a lot of project data stored in a data table. As I have Control Center generate new projects, I would like to be able to pull reports or information from Data Table to populate sheets in the project. This would include creating a table connection table to a sheet in my Blueprint, then having it populate the…
-
DataTable Variable
I have a DataTable containing time entries from 2023. I would like to bring them into each project and I can do that by manually connecting a sheet in each project to the DataTable and then filtering for the needed information. Currently my projects are built using Control Center. Is there a way where I can create a sheet…
-
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…
-
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…
-
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…
-
How to only Sum values for unique requests with a specific request type
Hello, I have created a sheet to calculate some data points based off of an archive of requests that get pulled from an Automation when Estimated Completion Date and Actual Completion Date are changed, and I am trying to setup a columns to display the Average Days to Completion for each request type to help with estimates…