=Count(children()) of multiple parent rows.

I'm trying to count the contents of multiple children in different cells for a grand total. I've organized my information by the media outlet, which will count its children for an "at a glance" total for ease of use. I would like the parent cell ("2 open inquiries") to count all the children for a total of all open inquiries. You can see that right now, it is only counting two instead of three. Is =Count(children()) the right formula for this task? There isn't a "grandchildren" function so I'm unsure of how this could be written.

I'm hopeful better minds than mine can help me figure this out.

(Note: I've scratched out sensitive information for obvious reasons.)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!