Totaling # the of projects that are older than 30 days, 365 days etc

Goal: how many open requests are older than the specified # of days old, this formula returns a result, just don't think it is the correct one as when I try to duplicate it and ask for requests more than a year old, the number encompasses ALL open projects in the last 365 days not the ones specifically older than a year:

=COUNTIFS({OPENED}, >=TODAY(-30), {CLOSED}, ISBLANK(@cell))

=COUNTIFS({OPENED}, >=TODAY(-365), {CLOSED}, ISBLANK(@cell))

Tags:

Best Answer

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭
    Answer ✓

    Hi MichelleR,

    A little bit changing for the operators as below. Try it!

    =COUNTIFS({OPENED}, <TODAY(-30), {CLOSED}, ISBLANK(@cell))

    =COUNTIFS({OPENED}, <TODAY(-365), {CLOSED}, ISBLANK(@cell))


    Gia Thinh Co. - Smartsheet Solution Partner.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!