=Min(Children()) not consistently updating for parent row

andrewreid8959556

I am trying to create a column of "Next Action" which will have a date for each row that is manually updated continuously.  I want the value of this column for the parent rows to update according to the next/oldest date (whether the furthest in the past, or the closest in the future) of the respective children rows.

I have been using the =MIN(CHILDREN()), which works one time, but then when I update a child date, the parent date does not update.  

Thank you for any help you can provide.

J. Craig Williams

Are the dates of the children manually updated or are they the result of a formula?

Are there duplicate dates and you might be missing the one that matches it?

I assume you delete the dates when the row no longer applies (this does not seem efficient)

I can not reproduce the issue as I understand it.

Craig

Paul Newcome

Can you show us some examples and give us more detail?