COUNTIFS Function - 0-30, 31-60, 61-90, >90 Days

Ryan Narlock

I got it working. Thanks so much Paul for all your assistance and activity with the Smartsheet community.

Any last thoughts on how to structure the formula for >

Paul Newcome

Happy to help. 👍️

And sorry, but I am not sure exactly what you are asking in that last question...

Ryan Narlock

Sorry, the end of my sentence must have got deleted somehow when I clicked submit. Wondering your thoughts on the formula for greater than 90 days old. I attempted the formula below but that did not work.

=COUNTIFS(Completed:Completed, AND(@cell >= TODAY(-91)))

Paul Newcome

Try thinking of dates as numbers where today is zero, tomorrow is one and yesterday is negative one. If you think about it that way, then what you are trying to accomplish is counting dates that are less than (today - 90 days).

=COUNTIFS(Completed:Completed, @cell <= TODAY(-91))

Ryan Narlock

Thanks again Paul! Is the any useful tools in troubleshooting formulas?

Paul Newcome

I use these two quite a bit when troubleshooting:

https://help.smartsheet.com/functions

https://help.smartsheet.com/articles/2476176-formula-error-messages?_ga=2.66067626.529420994.1554725353-1302373248.1552411124