COUNTIFS- date range in the last 7 days that meets criteria from two other coulmns also
Hi All,
Looking for a hand with a formula that will return a count for items that were in the last 7 days. The formula is pulling from another sheet for this data. Looking for the count of items, assigned to a specific person, are closed and closed in the last seven days.
Here is the formula I have but it is returning the wrong count. if I go the main page an filter it or build a report with the same info.
=COUNTIFS({Assigned To}, [Assigned To]6, {Status}, "Closed", {Closed Date}, <=TODAY(), {Closed Date}, <=TODAY(8))
Comments
-
Hi Glen,
Looks like you have two instances of the TODAY function in your formula, you only need one to accomplish what you want.
=COUNTIFS({Assigned To}, [Assigned To]6, {Status}, "Closed", {Closed Date}, <=TODAY(7))
If that doesn't work, try flipping the criteria a bit:
=COUNTIFS({Assigned To}, [Assigned To]6, {Status}, "Closed", {Closed Date}, >=TODAY(-7))
More on COUNTIFS here: https://help.smartsheet.com/function/countifs
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives