Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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
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.
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).
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.
