I want a formula that specifies the lowest child of an ancestor, parent, child hierarchy.


I am using the Hierarchy formula, =COUNT(ANCESTORS()), to label my project tasks. A lot of the child tasks have tasks below that, going to a hierarchy of 5. I want to create metrics sheet that shows the estimated completion date for the lowest level child. Because the levels vary by task, I cannot choose a specific hierarchy number to create that metric sheet off of.

The goal is to only count the tasks, not the parent lines.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!