finding items past due

edited 12/09/19 in Formulas and Functions

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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!