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!
@Andrée Starå - Looking for some help... What if I need to show all parents and children in the report ?
@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.
I would like the report to look like this after meeting the report criteria:
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!
Be safe and have a fantastic week!
✅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!
Hi Andree, Smartsheet community,
I have the same question. My scenario:
Parent Task 1 - Owner: Patty
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?
Hi @Lorena Cuadra
You’ll need to add helper columns, and it can get tricky.
How many different owners will there be?
Be safe and have a fantastic weekend!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD