Hi,
I want to count if range 1 contains value, or if it is any time in the future,
Range 1 is a restricted Date Column.
It should be something like this:
=COUNTIFS({Range 1}, "", >TODAY(), {Range 1}
What is the correct formula?
Thank you!
Hi @A Rose
You're close! In a COUNTIFS you first list the range, then you list the criteria. If you want to count the number of cells that are in the future, try this:
=COUNTIFS({Range 1}, >TODAY())
If you want to count two separate values, such as if it's blank OR if it's in the future, then you're right, you can use OR, like so:
=COUNTIFS({Range 1}, OR(@cell >TODAY(), @cell = ""))
Let me know if this works for you!
Cheers,
Genevieve
Amazing! Thank you @Genevieve P. !
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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
