finding items past due

shecodesit

This is a formula to find out how many tasks Jane Doe hasn't marked complete in the last 7 days.  It's not producing the correct number when I run it by a filter on the original dataset.  Any insights on how to make it more simplified?

 

COUNTIFS({Project List Range 3}, FIND("Jane Doe", @cell) > 0, {Project List Range 4}, <>"Complete", {Project List Range 2}, <=TODAY(7),  {Project List Range 2}, <TODAY())

Mike Wilday

I don't have access to the data but it seems like you might be trying to limit the data by a greater than and a less than, but I am seeing two less thans. <=Today(7) would also include <Today() Did you mean >Today()? 

Paul Newcome

That was also my first thought.

Mike Wilday

Did this solution work for you?