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.
Automate Child Row Based on Parent Row
Hello SS community. I am curious to know if there is a way to update a child row based on a parent row.
My real world scenario is as follows. I move children rows physically on the page into one of 6 sections contained by parent rows.
When I move a row into the 'Completed' section, I would like the status column to change to complete.
Is this possible? I see many posts on how to update a parent row based on a child status, but not the other way around.
This would be so useful since sometimes items are moved around but the status neglects to be updated : /
Thanks.
Comments
-
Robert,
There may be a few ways to do this, but here's a pretty simple one. Put the following formula in the Status column and it'll pull the value from the same column of the parent row:
=INDEX(ANCESTORS(), 1)
So you can move child rows from one parent row to another and it'll update that Status column accordingly.
Here's an example of a thread that touches on this:
https://community.smartsheet.com/discussion/how-display-grandparent-task-name-or-value-cell
Hope that helps,
Matt
