brandon.elmer’s Profile

Community member since February 2018

points
51

4

Hi Everyone,

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