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.

Parent Rows not Updating from Child Last Modified

Options
Claire Diener
edited 12/09/19 in Archived 2016 Posts

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

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    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
    Options

    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
    Dave D
    edited 04/19/16
    Options

    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
    J. Craig Williams ✭✭✭✭✭✭
    Options

    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

This discussion has been closed.