COUNT IFS for Assigned Person
I want to count the number of tasks due within a certain time frame, let's say next 7 days. I have found the following formula to work:
=COUNTIFS([Due Date]:[Due Date], >=TODAY(), [Due Date]:[Due Date], <=TODAY(7))
However, I now want to expand the formula so it is only counting the number of tasks due that is assigned to a specific individual. I have not been able to figure out which formula to make this work.
Does anyone have some suggestions I can try?
Answers
-
Hello @Jstaley11
Are you allowing multiple contacts in the Assigned To column? If not, one can try this formula
=COUNTIFS([Due Date]:[Due Date], >=TODAY(), [Due Date]:[Due Date], <=TODAY(7), [Assigned To]:[Assigned To], [Assigned To]@row)
Be sure to edit my formula so that the column name matches your actual Assigned to column name.
Does this work for you? If not, a screenshot of your sheet will help the community.
Kelly
-
@Kelly Moore It does not seem to work. Here is a screenshot.
Help Article Resources
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
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!