COUNTIF matching two criteria


I'm trying to count if, a row matches two criteria:

  1. The row status is not "completed" (in another column)
  2. If the current date is greater than the value in another column: "Due date".

So example:

Clean Bathrooms Not Completed 12/1/2020

The above row would be counted on the formula because it's not completed and past the due date.

Best Answers


  • Pete Cardenas

    Yup this does!

    I didn't know if you could keep putting multiple criteria in the parenthesis.

    Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!