COUNTIF formula that will return the # of DESCENDANTS from a specific Task and exclude CHILDREN
(New User btw) Understand how to get the # of total Descendants from a specific Task, but want to exclude the # of Children so I am only counting Grandchildren.
Would also like to have the formula FIND a specific Task name and use that as the Task reference.
I have an "Indent Level" column and have tried using it so that the formula would only count Indent Level = 2 but could not get it to only count the tasks that = 2 for a specific parent task instead of all tasks.
Help Article Resources
Check out the Formula Handbook template!