Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
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 ?
Comments
-
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.
-
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.
-
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
