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.

How to have child rows displayed using parent data

Options
David Muskett
edited 12/09/19 in Archived 2017 Posts

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 

 

Comments

  • David Muskett
    Options

    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
    Brett Evans ✭✭✭✭✭✭
    Options

    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
    Omar
    edited 04/01/19
    Options

    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
    Options

    Sorry for the delayed reply.

     

    Yes, Brett's solution tidies up the sheet nicely

     

    Many thanks

This discussion has been closed.