COUNTIF date is this month in Summary Sheet
Hello!
I'm trying to count the number of pursuits that are due("Response Date" column) in the next 30 days. I'm currently using this formula in my Summary Sheet:
=COUNTIFS([Response Date]:[Response Date], =MONTH(TODAY() + 30))
But, it's not working. Can someone please help?
Thank you!
Answers
-
Try using this:
=COUNTIFS([Response Date]:[Response Date], >=TODAY(), [Response Date]:[Response Date], <=TODAY(30))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!