CountIF Children Overdue

ilya kern

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 ?

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