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:




Best Answer

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

    Hi MichelleR,

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



    Gia Thinh Co. - Smartsheet Solution Partner.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!