Task not complete and overdue

I have a % Complete field and a Finish date field. When % Complete <>100% and the Finish date is in the past, what COUNTIF formula do I use? Also, some Finish dates may be blank as they have not yet been given a date. Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!