How can I calculate the correct task count on project plan?

monica.aten

Hi, Community. I need ideas on accurately computing the task count. My project plan has child tasks but counts the parent tasks. Thank you😀

Nic Larsen

I do this with 2 helper columns:

Level Column: =IF(COUNT(CHILDREN([Task Name]@row)) > 0, COUNT(ANCESTORS()) + 1)

Task (CheckBox): =IF(Level@row >= 1, 0, 1)

Then you can count the number of Checkboxes.

monica.aten

Thank you, @Nic Larsen 😀 I'm going to try that.