How to have child rows displayed using parent data

David Muskett

Hi all,

 

I have a complex sheet which is efectively a "to do" list.

Thanks to the community I have it working pretty well as I want and am very happy with it.

 

To polish the sheet, I would like to achieve the following:

 

I have my todo's organised by project then category. For example, I have a column called "project" which is a dropdown list of all my projects. Then I have various parents "issues" which have child categories.

Obviously, the parent (issues) has must align to a project and logically (to me) all childs (issues) must have the same project as the parent. I currently get round my problem by manually allocating the project to all childs. Basically I do this so that when I filter I can see all issues associated with a selected project, both parents and childs.

In my opinion, this makes for a messy spreadsheet.

 

Is it possible (I am sure it is but lack the knowledge to implement) to have all childs inherit the project associated with the parent?

 

Or, to put it another way, I want to filter based on Project and have it  show all parents and their associated childs?

 

 

 

Thanks in advance.

David 

 

David Muskett

Hi all,

I have played a little using this :

=PARENT([Project]102)

 

But this does not work well in my situation.

 

If I paset the formula down the entire column it returns blank if the issue is not in a partent/child relationship. For me, it has no advantage over creating the project manually agains each child.

 

I will report more if I find the answer myself

 

Thanks

David  

Brett Evans

David,

Does this help take care of the blanks - or at least some of them?

 

=If(Isblank(PARENT([Project]102)), [Project]102, PARENT([Project]102))

 

 

-Brett

 

Omar

Thank you so much for this Brett! I've been racking my brain to find a solution. Never would have thought of "Isblank". How would I deal with "grandparents" ?

David Muskett

Sorry for the delayed reply.

 

Yes, Brett's solution tidies up the sheet nicely

 

Many thanks