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

Andre O

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

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?