Count Issues Resolved Today

Options

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 .

Tags:

Best Answer

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

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

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

    Mark


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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!