Date filter not in effect when I reference a Sheet. And, COUNTIFS/CONTAINS issue

I am trying to pull info into a helper sheet from another sheet that I have filtered to only have items with a completed date in 2024.

When I then insert the reference to that filtered sheet it is not showing just the filtered items I want, but dates going back to 2020.

Is there a fix for that?

Once that is fixed, I would love to be able to count a how many times a few people have completed jobs.

For instance, we have 3 people that fall into one department and I want to group them all into 1 department on the helper sheet. Right now I can only get it to return info for 1 person.

=COUNTIF({Quote Person}, ("Mike Collison"))

That is my current formula, I have tried plugging "CONTAINS" and the other names that I want to include with no luck

Find more posts tagged with

Accepted answers

All comments

Mark.poole

Create a reference for the completed date column as well then Use this formula

=COUNTIFs({Quote Person}, "Mike Collison",Year({Date Ref}),2024)

Andre O

Hey, Mark, I am getting an Invalid Data Type error with the formula.

=COUNTIFS({Quote Person}, "Mike Collison", YEAR({Quote Complete Year}), 2024)

These are the two columns that I am referencing in the formula.

Mark.poole

I just found this response, and apologize if the issue was never answered. Is your date column in a date row or is it text?

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.