How to count number of rows where a date in a column is equal to a specific date?

Hi all,

I am trying to create a time series line chart to show the progress of issues put in a specific status every day. On our Issue log, we have date column which captures the date on which an issue was set to either Rejected, Closed or Acceptable Difference. Created a supporting sheet to map the data for the chart below. For Ex: I am trying to get the total number of issues put in Rejected status on 16th Oct. But its currently returning 0. Can someone please help with am I doing wrong in the formula?

Formula in these cells - =COUNTIFS({MSI Model Office Testing Log - Status}, Rejected1, {MSI Model Office Testing Log Range 2}, $[Issue Close Date]@row)

Note - both the date columns are of type Date

Find more posts tagged with

Accepted answers

svijay22

Hi @Paul Newcome - yes, please see below. Anything else I might be doing wrong?

Column which captures the date when any of the rows are put in any of the three statuses above -

Column where I have daily dates to map the data for the time series line chart -

All comments

Paul Newcome

Have you ensured that both date columns are in fact set as date type columns and have date type data in them?

svijay22

Hi @Paul Newcome - yes, please see below. Anything else I might be doing wrong?

Column which captures the date when any of the rows are put in any of the three statuses above -

Column where I have daily dates to map the data for the time series line chart -

svijay22

@Paul Newcome - apologies, its now working. I just had a minor user error. Thanks for your time.

Paul Newcome

Happy to help. 👍️

LesahDee

I am cross referencing 2 different sheets getting an error can someone help.

=COUNTIF({Munis Range 1}, "Facilities", {Contract Extensions Range 1}, NOT("Expired", "Closed"))

I want it to count if the first range is "Facilities" and if the second range is NOT "expired" or "Closed"

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.