COLLECT in CHILDREN based on another column's value in CHILDREN scope
I am trying to find the min value of CHILDREN in a column of numbers where the value of the [% Complete] cell in the row of that column is not = 100%, but, again, only for the CHILDREN.
=MIN(COLLECT(CHILDREN(), [% Complete]:[% Complete], @cell < 1))
=MIN(COLLECT(CHILDREN([Days Till Due]:[Days Till Due]), CHILDREN([% Complete]:[% Complete]), <1))
in my [Days till due] column, for example, does not work. I get a #CIRCULAR REFERENCE error
On a related note, what kind of argument does CHILDREN take?
Help Article Resources
Check out the Formula Handbook template!