COUNTIF Formula Question
I'm trying to determine a COUNTIF formula to show what deliverables are due in the next 7 day period based upon a Due Date column. However, I'd like said formula to only showcase what deliverables are in the next 7 days and ALSO be able to EXCLUDE all projects that become overdue.
So essentially I'd like a COUNTIF formula to only showcase what documents/projects are due within the next seven day time span.
So far I have come up with the following equation. It works, however I'm failing to make it also exclude any projects whose due dates fall out of said due date period. It will continue to showcase deliverables that technically are overdue, which I'd like to exclude, as I already have an overdue column.
=COUNTIF([Due Date]:[Due Date], <TODAY(+7))
I was wondering if anybody had any suggestions, as I have completely exhausted my idea bank. Thanks!
Comments
-
Just time for a quick note. Try using two COUNTIF functions in the same formula. The first could count everything in the future then subtract another COUNTIF that looks a week out and farther.
To eliminate counting items that are overrunning use the COUNTIFS function instead and only count items that are not overrunning.
Sorry, I don't have more time to be more specific.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 297 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!