COUNTIFS formula between a specific date range
Hello SmartSheet Community! I am trying to write a formula that will capture project deliverables status between a specific date range and I keep getting an error. I thought the below formula would work, but I am wrong, lol. Any ideas?
=COUNTIFS(Status:Status, "Not Started", ([Start Date]:[Start Date], >=DATE(2022, 10, 1), ([End Date]:[End Date], <=DATE(2022, 12, 31))))
Best Answer
-
Hi Dan, I think your parenthesis were out of whack 😁
=COUNTIFS(Status:Status, "Not Started", [Start Date]:[Start Date], >=DATE(2022, 10, 1), [End Date]:[End Date], <=DATE(2022, 12, 31))
Try that one ^ and please let me know if it works for you.
Ryan
Answers
-
Hi Dan, I think your parenthesis were out of whack 😁
=COUNTIFS(Status:Status, "Not Started", [Start Date]:[Start Date], >=DATE(2022, 10, 1), [End Date]:[End Date], <=DATE(2022, 12, 31))
Try that one ^ and please let me know if it works for you.
Ryan
-
Ryan, you are AWESOME! Thank you for the quick response, and yes, it worked! Very much appreciated 🙏
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!