What am I doing wrong? Trying to count how many say not started in the month of dec 2020.
COUNTIFS({Request Tracker Range 2 - Status}, CONTAINS("Not Started") >= DATE(2020, 12, 1), {Report Request (Test Version) Range 3}, <=DATE(2020, 12, 31))
Best Answer
-
Thank you @Mark Cronk & @Mike Wilday I will try it out and see if it works.
Answers
-
What are you trying to do with teh Contains("Not Started") bit there?
-
Hi @DeMetria Hines ,
Try:
=COUNTIFS({Request Tracker Range 2 - Status}, "Not Started", {Report Request (Test Version) Range 3}, month(@cell)=12))
Assumes your status is in range 2 and dates in range 3.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Range 2 is a drop down, so I am trying to count how many in that column set to not started in the month of December.
-
I think Mark's solution would work for you. Have you tried it out?
=COUNTIFS({Request Tracker Range 2 - Status}, "Not Started", {Report Request (Test Version) Range 3}, month(@cell)=12))
-
However, If you want to restrict it to a specific date range. This one should work for you too :
=COUNTIFS({Request Tracker Range 2 - Status}, "Not Started", {Report Request (Test Version) Range 3}, And(@cell >=DATE(2020, 12, 1), @cell <= Date(2020, 12, 31)))
-
Thank you @Mark Cronk & @Mike Wilday I will try it out and see if it works.
-
Awesome. Let us know if you have any trouble.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!