COUNTIFS formula for any future date?
Hi all,
I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date.
I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working.
Any advice would be appreciated! Thank you.
Best Answer
-
try this =COUNTIFS({due date column's range}, @cell>=TODAY())
Also, keep in mind that the today formula does not update unless the sheet is opened and saved everyday. There are some workarounds to this issue.
Answers
-
try this =COUNTIFS({due date column's range}, @cell>=TODAY())
Also, keep in mind that the today formula does not update unless the sheet is opened and saved everyday. There are some workarounds to this issue.
-
@Samuel Mueller Wow, thank you so much for the quick response! It looks like that formula worked!
That is a good tip to know. What are those workarounds? The sheet is usually used and saved daily, but in case of holidays, would the formula stop working?
Thank you again :).
-
@Jenna2424 take a look at this post, has a good explanation how to get around it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 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
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!