COUNTIF CHILD AND UNRESOLVED
Options
K Munz
✭✭
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
-
Give this a try...
=COUNTIFS(CHILDREN(Resolved@row), 1)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!