I am trying to count project tasks that are in any status except "Complete" and due in 7 days.

ShaneL. ✭✭
edited 03/28/23 in Formulas and Functions

Hi. I'm trying to count tasks due in the next 7 days that aren't completed, but it's still counting past the 7 days. Any help is appreciated!

Heres the formula I tried using:

=COUNTIFS(Status:Status, <>"Complete", [End Date]:[End Date], AND(@cell >= TODAY(+7)))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!