How to get the formulas to correctly count the completed tasks?
The current formula counts every task for the total.
=COUNTIF(DESCENDANTS([Planning Done]@row), 1) + " of " + COUNT(CHILDREN([Task/Topic]@row)) + " Done"
I have been trying to get it to only count when all subtask from its proper row have been completed.
There are 4 tasks and over 60 subtasks. When the subtasks are completed I want the 0 of 4 to accurately reflect that. Not count every single subtask towards it.
When I changed it from Descendants to Children it won't count at all.
=COUNTIF(CHILDREN([Planning Done]@row), 1) + " of " + COUNT(CHILDREN([Task/Topic]@row)) + " Done"
Is there something I'm missing?
Help Article Resources
Check out the Formula Handbook template!