Creating report to show all Parent Row based off Child Row
I'm trying to create a report to display all tasks assigned to logged user (current user option).
I want to see all the parent rows for all children, i.e. if current user is Jane, I want all the children tasks showing but also want to see the parent task it is related to.
So, in report, if Jane logs in for task 2.1.2 I would like to see parent 2.1 F, 2.0 C and A.
I have many small projects like these so this is example of just one of them.
Another question is, I want the parent row to update to complete (green) automatically when children are green, how do I do that?
Thanks in advance for the help.
Attached the template of my smartsheet as an excel