Count if Question

I have a formula I am trying to figure out -

It is a parent/child formula

needs to be

  1. one condition met in one column
  2. one of 2 possible conditions met in another column

Keep getting error

Here is my formula for now -

=countifs(children([Issue Type]@row, "defect", children(OR(Status@row, "New", "In Progress"))))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!