COUNTIFS Status and Year is Current(Cross-Sheet Formula)

Hello Community…

Stuck trying to work out a COUNTIFS formula for Status is X and Year from a date column is current year,

The first part I have…

=COUNTIFS({Status}, "Pending Submission",

The second part I am looking for help in this the {Submission Date} which is currently a date column is the current YEAR.

I have this working with the use of a helper column as per below but wanted to know if this be achieved without a helper column to extract the year?

=COUNTIFS({Status}, "Pending Submission", {Helper Column-Submission Year}, YEAR(TODAY()), {Another field}, 0)

Grateful for any help/advice,

Protonsponge

Find more posts tagged with

Formulas

Accepted answers

Carson Penticuff

Give this a try:

=COUNTIFS({Status}, "Pending Submission", {Submission Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

All comments

Carson Penticuff

Give this a try:

=COUNTIFS({Status}, "Pending Submission", {Submission Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Protonsponge

Thank you @Carson Penticuff, that worked perfectly - very thankful for your insight!

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.