Count by date and person


I have successfully used the formula below to return a count of submitted issues on a log that have been resolved within the past week. I need to now take this amount and record the count by staff member who resolved the issue. On the source sheet I have a column where the individual is listed "First name Last name".

=COUNTIFS({Resolved Date Range}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()), {Resolved Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!