Counting Incomplete Past Due Activities by Category
Hi all,
I'd like to get a total count of the activities in my project plan which meet the following criteria:
1) "Expected Due Date" is past due (<= Today)
2) "Expected Due Date" is not blank
3) "Done?" is unchecked
4) "Category" is "ABC"
I assume I'll need a check box column with a formula to indicate if these criteria are met, followed by a count formula to calculate the number of boxes checked. Any recommendations are greatly appreciated!
Best Answer
-
Hello @JazzyJ
The COUNTIFS formula will provide this count for you. If desired, you could add this formula to a Sheet Summary field (found in right hand menu on sheet). I am assuming this formula is within the same sheet that you are counting - vs putting the formula in a different sheet and pulling the values as a cross sheet reference)
You will need to substitute your actual column names into this formula.
=COUNTIFS([Expected Due Date]:[Expected Due Date], <=Today(), [Expected Due Date]:[Expected Due Date],ISDATE(@cell), [Done?]:[Done?], 0, Category:Category, "ABC")
cheers
Answers
-
Hello @JazzyJ
The COUNTIFS formula will provide this count for you. If desired, you could add this formula to a Sheet Summary field (found in right hand menu on sheet). I am assuming this formula is within the same sheet that you are counting - vs putting the formula in a different sheet and pulling the values as a cross sheet reference)
You will need to substitute your actual column names into this formula.
=COUNTIFS([Expected Due Date]:[Expected Due Date], <=Today(), [Expected Due Date]:[Expected Due Date],ISDATE(@cell), [Done?]:[Done?], 0, Category:Category, "ABC")
cheers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!