Summarize Issues Resolved Last Month by Assignee

Options

I want to summarize the # of tickets completed last month broken down by assignee. I know the formula to bring back the # of resolved tickets, but what formula would I use further break it down by assignee?

=COUNTIFS([Resolved Date]:[Resolved Date], IFERROR(MONTH(@cell), 0) = MONTH(TODAY([Issues Resolved Last Week]#)), [Resolved Date]:[Resolved Date], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

For example if Person 1 completed 2 tickets and Person 3 completed 5

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!