Count Issues Resolved Today


I am trying to create a formula that will count the number of issues resolved with today's day. I've tried using

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

It counts okay, but it does not give me the correct value.

Once I get that working I would like a formula that will count the items with a Resolved Date of the day prior so that I can show tickets resolved today and yesterday separately .


Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    For today: =COUNTIF({Resolved Date Range}, @cell=TODAY())

    For yesterday: =COUNTIF({Resolved Date Range}, @cell=TODAY(-1))


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!