Show both parent and child rows in report, even if the Parent doesn't meet the criteria

Show both parent and child rows in report, even if the Parent doesn't meet the criteria

edited 05/25/20 in Using Smartsheet

i have sheet with parent and children tasks and in my report i want to see the children tasks with the parent row.

when i try to do this i show only the children..


there is any way to show chldren tasks with parents in report>??

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Netanel,

    Yes, there is.

    Do you want to show all parents and children or only specific ones?

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • hi,

    here the link to sheet:


    im have report that show the row that not has a "Eng. approveed" and the "status" "ממתין לאישור חוזר של יוני"

    (status in hebrew sorry)

    and i want to shw in report the children row and the parent.

    only the children get the yes /not "Eng. approved"

    the parent not specific value - can be empty or hold ...

  • I'm also curious how to do this, Andrée. Is there an easy way to describe how if the parent and child rows already exist?

  • hi,

    i email with Andrée and he wrote a formula that meets with my needs. 

    you can edit and use to you needs.


    =IF(AND([Eng. Approved]@row = "No"; [email protected] = "value"); 1; IF(COUNTIFS(CHILDREN([Eng. Approved]@row); "No"; CHILDREN([email protected]); "value") > 0; 1))

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Netanel yosef Thanks!

    @Michael Ponte Let me know if you need additional help!

    Have a fantastic weekend!

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • edited 04/09/20

    @Andrée Starå - Looking for some help... What if I need to show all parents and children in the report ?

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Harish Dharmarajan

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • @Andrée Starå I have been stuck by this issue as well. How can I get the same Sheet Filter "include parent rows" effect in Reports?

    I have sheets that have different levels of indents, and some tasks that have the same names belong to different indent parents (different phases for example). I want to create reports that shows tasks that are upcoming/at risk/overdue (meeting certain criteria). The formula works, but they only show the children. Because some of my children belong to different parents (phases), I have no idea which task it is.

    So I need a way to display the parent rows (parent as well as grant parents preferred) in the report to differentiate. If the report could also intent them like in the sheet filter, that will look even better.

    For example,

    I would like the report to look like this after meeting the report criteria:

    Grandparent 1

    Parent 1

    Child 1

    Child 2

    Parent 2

    Child 1

    Child 2


    Thanks,

    --Annie

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Annie Cheng

    It depends on the filter and what you want to show. Usually, I create a so-called helper column to Indicate if something in the children is true then show the parent.

    It can get tricky to make it work!

    Make sense?

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andree, Smartsheet community,

    I have the same question. My scenario:

    Parent Task 1 - Owner: Patty

    • Child task 1 - Owner: Rick
    • Child task 2 - Owner: Jay


    Rick needs a report that shows every project he owns (Filter: Owner = Rick) - using the Report Builder.

    And this report view also needs to show any parent or child associated to his task(s) - have visibility to the entire "family". The report should also show "Parent Task 1" and "Child task 2" as well.

    Is there a way to do it using Reports? do I need to create a column with some additional flags?

    Thanks,

    Lorena

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Lorena Cuadra

    You’ll need to add helper columns, and it can get tricky.

    How many different owners will there be?

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.