Summary by name and date range
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
Check out the Formula Handbook template!