Is there a formula/function to help count number of children assigned to specific parent tasks?

Hi all,

I'm trying to put together a table that lists the number of sub-tasks (children) in each respective Workstream (parent) of a specific Project Plan, and also breaks these down into their respective Health Status (Green, Yellow, Red).

I am aware that I can apply a "COUNTIF" formula and set the range to encompass the children underneath each respective parent group. However, my concern is that the formulae will need to be subsequently updated each time more tasks are added to a given workstream.

On that note, is there a formula or functionality I can use that detects a parent/child relationship, and that I can use in this instance?

Many thanks in advance for your help on this, I look forward to hearing from you!

Kind regards,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!