Counting Past Due Task on a Sheet

Hello,
I'm trying to see if there is a way I can put a countifs function into a project plan template that will allow users to keep a rolling tally of any tasks not 100% complete and in the past. Ideally i would like this to only look at milestones (0 duration) as i'm going to collect this from every sheet and place on a dashboard.
Thank You,
Comments
-
Hello Sam, Try this.
=Countifs([Start Date]:[Start Date], < today(), Duration:Duration, =0)
-
=Countifs([Start Date]:[Start Date], < today(), Duration:Duration, =0)
^
the equals sign is not needed.
Craig
-
Thanks Craig! Totally missed that.
-
No worries. It isn't wrong, just unnecessary.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives