Ignore Summary Task When Counting Late Tasks

I use the formula when counting late tasks:  =IF(ISBLANK(Finish107), "", IF(AND(TODAY() > Finish107, [% Complete]107 < 1), 1, ""))

The issue with this is that it also counts summary tasks which really aren't tasks themselves.  Is there a way to ignore summary tasks so I don't have to manually delete the formula in the cell in the Late Task column?

summary late task.PNG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!