Number of Tasks
I have a sheet that I am trying to get the number of total tasks to match up with the number of completed tasks.
I have two columns
- "Is Task" which is a checkbox column that i use the formula =IF(COUNT(CHILDREN(Tasks@row)) = 0, 1, 0). This checks only the tasks and not the parent rows.
- "Status" in which I use the formula =IF([Actual % Complete]@row = 1, "Complete", IF([Actual % Complete]@row = 0, "Not Started", "In Progress"))
I count the "Status" using multiple formulas for each state such as =COUNTIF(Status:Status, "Complete") and I count the "Is Task" using =COUNTIF([Is Task]:[Is Task], 1)
The issue is when i count the Status, it will count al the rows in the project which does not equal just only the tasks. I am thinking the formula I am looking for is to count the status on rows that are only as tasks.
Thanks for any help.
Help Article Resources
Check out the Formula Handbook template!