Summary by name and date range

edited 12/09/19 in Formulas and Functions

I will try to explain the best I can.  I don't have the Pivot app, so wondering if there are any other "tricks" that might work besides exporting to Excel.  We are using Smartsheet to log everything that goes through our final testing department.  So, assembler, qty inspected, qty rejected, date, etc.  Is there a way to summarize qty inspected and qty rejected for each assembler in a certain date range?  For example, for the month of October I want to see a summary like below.

Assembler    qty inspected     qty rejected

John              200                     10

Joe                300                      5


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!