Count if Children Rows are Completed

swirt009

Hi All,

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!

Paul Newcome

Your second range should also be a CHILDREN function.

CHILDREN([Completed Date]@row)

swirt009

Thanks, @Paul Newcome!

The new formula I entered was:

=COUNTIFS(CHILDREN(Task@row), <>'', CHILDREN([Completed Date]@row),"")

For some reason, that returned a "#UNPARSEABLE".

Did I do something wrong?

Paul Newcome

You're missing the second quote after <>.

You have

<> "

You need

<>""