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.

Find more posts tagged with

Formulas

Accepted answers

Samuel Mueller

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.

All comments

Samuel Mueller

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.

Jenna2424

@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 :).

Samuel Mueller

@Jenna2424 take a look at this post, has a good explanation how to get around it.

https://community.smartsheet.com/discussion/99643/new-help-article-automatically-update-the-today-function-in-formulas

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.