Can anyone recommend the best formula to calculate overdue tasks?

Currently using- =COUNTIFS(AND({SS Project Plan Completion Date Range}, NOT([{SS Project Plan Status Range} = "Complete")]) < TODAY())

I want to exclude completed task from the count. Currently returning UNPARSEABLE error



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!