COUNTIFS Function - 0-30, 31-60, 61-90, >90 Days
Answers
-
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:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!