COUNTIF CHILD AND UNRESOLVED

Options
K Munz
K Munz ✭✭
edited 12/09/19 in Formulas and Functions

I have a sheet where we are tracking comments from various agencies.  Each agency lists their comments as children under a parent row of the agency name.  A separate checkbox column indicates whether the comment is resolved.

I am trying to create a formula to calculate the number of unresolved comments per agency in each parent row - I can't determine if this is a COUNTIF or COUNTIFS function.

Here's what I have at the moment:

=COUNTIF((CHILDREN()), Resolved:Resolved, 1)

Appreciate any feedback!

thanks.

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!