Counting Projects that are 1 Week or More Behind Schedule
I got a great formula from Customer Success that I thought I would share. I wanted a way to know if a project was at least 1 week or more behind schedule. This is what Customer Success gave me:
=COUNTIFS(Finish:Finish, TODAY() <= TODAY(-7), [% Complete]:[% Complete], <>1)
This formula counts tasks that are 7 days late or more and if the percent complete does not equal 100%. So I just create a new column in my project plans and put this formula at the top. Brilliant!
Help Article Resources
Check out the Formula Handbook template!