Counting Past Due Task excluding marked complete

bmcmichael48661
edited 12/09/19 in Formulas and Functions

Hi! Is there a way to count all tasks that are past due based off of date, but exclude tasks that are marked complete? 

=COUNTIF(Finish:Finish, <TODAY()) 

Can I add an exemption in this so marked complete is not counted? 

 

Please let me know! 

 

Branden 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!