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>??
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!
Workflow Consultant / CEO @ WORK BOLD
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?
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))
@Netanel yosef Thanks!
@Michael Ponte Let me know if you need additional help!