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
Comments
-
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.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives