COUNTIF matching two criteria

Options

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

Answers

  • Pete Cardenas
    Options

    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!