Count if Children Rows are Completed


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!