Need a formula
I am novice at best when it comes to anything related to formulas! I collect data in a grid format starting with a "Date Created" column. In a 24 hour period there are typically 5060 entries. Each entry collects two points of data, in this case Weight and Gauge of material. Each column compares actual to a specification and is color coded red, green yellow. I created a separate grid that that I am filling out manually based on the collected information: Below is what I am manually collecting:
I need a formula to calculate this automatically.
Any help would be appreciated!
Answers

You need a formula to calculate what exactly?

Below is how I collect the data. This happens 50+ times in a 24hour period.
This is how I am compiling the data to chart. I need the below table to generate automatically. I am doing this manually, counting the number of above, below and on target etc.

To get a count from another sheet of rows that have multiple range/criteria sets, you would use a COUNTIFS.
=COUNTIFS({Gauge Column}, @cell < 0.95, {Date Column}, DATEONLY(@cell) = Date@row)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!