parent row in report

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

parent row in report

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

Sign In or Register to comment.