Hi again,

I am trying to write the following formula and am not getting the answer I am looking for. My goal is to count the late items in a task sheet. This require two parameters to be met.

  1. the date is in the past
  2. the progress status is not "Complete"

=COUNTIF(AND({Due Date Range}, <TODAY(), {Progress Range}, <>"Complete"))

#2 can also be accomplished by saying the {Done Range} is not checked.

Please advise where I am going wrong.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!