finding items past due
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())
Tags:
Comments

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()?


Did this solution work for you?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!