CountIF Children Overdue

Hi Team,

I am trying to count how many of the child rows are overdue and am stuck on the syntax for the formula. This is what I currently have - =COUNTIF(CHILDREN([End Date]4), <TODAY()) - but I am getting a "unexpected operator" error.Can someone please advise how this should be written ?

Find more posts tagged with

Comments

Brett Evans

Add a hidden column that returns the value 1 if the child is overdue.

Use COUNT on the hidden Column to see how many are overdue.

COUNTIF is expecting a single value, not a comparison for the second argument. That is why you are getting the error message.

ilya kern

Thanks for that Brett. I was assuming it would work the same as it does in Google Sheets/Excel. Looks like I have to take a slightly longer approach then.

Brad Jones

There is a solution!

I am using it now to count if the children of a row have a certain value in the first column.

=COUNTIF(CHILDREN(Column1), "COM")

Ilya,

You might try this link:

https://community.smartsheet.com/discussion/average-complete-if-task-assigned-xxx