Count if Children Rows are Completed
I need a formula that counts how many children tasks don't have a completed date entered yet. See the screenshot below.
My formula is:
=COUNTIFS(CHILDREN(Task@row), <>"", [Completed Date]:[Completed Date], "")
However, it returns an incorrect argument.
Any suggestions would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!