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 >
Happy to help. 👍️
And sorry, but I am not sure exactly what you are asking in that last question...
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)))
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))
Thanks again Paul! Is the any useful tools in troubleshooting formulas?
I use these two quite a bit when troubleshooting:
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
©2022. All Rights Reserved Smartsheet Inc.