How to find out if Project is late
Hello,
I am trying to create a Sheet Summary field to let me know if the overall project is late. I have the below formula which seems to not be working:
=IF(AND(MAX(Finish:Finish) < TODAY(), MAX(Status:Status) <> "Complete"), 1, 0)
My logic is to take the max finish date and see if it is less than today, in addition I want to check that that task's status is not equal to "Complete".
Any assistance would be appreciated. I am a SmartSheet formula n00b. Thanks,
Best Answer
-
Try something like this...
=IF(AND(MAX(Finish:Finish)< TODAY(), COUNTIFS(Status:Status, AND(@cell <> "", @cell <> "Complete")) > 0), 1)
Answers
-
Are you able to provide a screenshot so that we can see the overall structure of the sheet?
-
Here you go. It is a very basic template. I know a lot of people create columns within the sheet as indicators. I was going the sheet summary route to not make it so cluttered.
-
Try something like this...
=IF(AND(MAX(Finish:Finish)< TODAY(), COUNTIFS(Status:Status, AND(@cell <> "", @cell <> "Complete")) > 0), 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!