Parent Rows not Updating from Child Last Modified

Claire Diener

Hello!

I have a column to track the time a row was last modified. This works great for my childrows, but my parent rows don't reflect the modification date of the child rows. Is there a way to have them pull from the child rows rather than its row (which will never change)???

Thanks,

Claire

J. Craig Williams

Claire,

 

I assume you are using the System column for Modified (Date).

You can't put your change there, since it is system column (no formula allow)

 

Add a new column. I called mine MaxDate

 

Add this formula

=IF(COUNT(CHILDREN(Modified23)) > 0, MAX(CHILDREN(Modified23)), Modified23)

 

to row 23 and then copy it to the rest of the column.

 

This will show the DATE the most recent child has been updated.

The TIME in the Modified (Date) column is ... well, difficult to extract.

 

Be aware that you will also be experiencing the Heisenberg Principle. 

You can't add the date change of the child to the parent without effecting the parent.

Your statement "which will never change" has now been changed to "it will change because of my formula"

 

This will also roll up all the way to the top if you have multiple levels.

Each parent will be updated by its children which will impact ITS parent, and so on.

 

Craig

 

 

Dave D

You could also just add this anywhere on your parent row:

 

=MAX(CHILDREN(Modified4))

 

(Add  + "" at the end if the formula is NOT located in a Date column)

 

This will show the max date of the child row Modified Date column for the modified. This will change whenever the child row is updated and will in turn show the parent row as modified the same date. 

Dave D

There is more than one way to skin a cat!

 

Its always good to reduce the number of possible errors (such as forgetting to add the formula to the parent row). 

J. Craig Williams

Dave,

 

The difference is your solution has to be copied to each parent row.

That's what I am trying to do with out having to think about if I missed any parents.

 

Craig