Counting # of tasks from a specific parent

Hi all,

I am trying to count the number of tasks in my plan underneath a specific heading. However, I am unsure how to do this for 1 parent heading and not all of them.

For example, I am looking to find the number of tasks under plan stage 2.

  • Plan stage 1
  • Plan stage 2
  • Plan stage 3

I would use "=COUNT(CHILDREN([Task Name]@row))" in the plan and use a countif for anything that =0. However this would count everything for plan stage 1, 2, 3.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!