Count Raised flags under child and grandchildren

Hello everyone,

I am trying to wrap my head around this one and I'm sure others have too.


I want to count all the Flags that are raised under a grandfather (Administration) : the children and their grandchildren.

Currently my solution works, but it's weak. It depends on a fixed range, and as time goes on, new grandchildren and children are added. If the formula's range is not updated, important flags can go unreported.

Here's the formula:

=COUNTIF(Flag3:Flag27, 1) + " Flag(s) raised"


If I could somehow make this work by including the COUNT(CHILDREN()) formula it'd be nice but I can't wrap my head around it. Any feedback would be appreciated.











Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!