View parent (and child) rows in report?

Phil Wightman

Is there a way to view parent and child rows in a report?

Asking as using the std project dashboard with 'At risk tasks' report (from the schedule).

This surfaces rows where due date is in the past and status other than complete.

However, for lengthy schedules it surfaces child rows that have no context when in a long list of tasks without their parent row for context.

Any solutions out there?

Andrée Starå

Hi @Phil Wightman,

I hope you're well and safe!

Do you only need to see what parent the child is part of or any other information?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Phil Wightman

Hi @Andrée Starå

I'm well thank you. Hope you are too.

I want to see both. The issue with the report is that it's 'flat' with no structure and the content has no context. I guess one solution would be to include the parent row as part of the child description but this seems a little bureaucratic and contra what Smartsheet is meant to help with!?

Genevieve P.

Hey @Phil Wightman

Here are some other Community threads that talk about possible solutions:

• Grouping with Parent Rows in Report
• Way to tell a report to include the parent row info for child tasks?
• Creating report to show Parent Row based off Child Row
• How do I show child AND PARENT rows in report?

Please also feel free to vote on this Product Idea thread to pass your feedback along to the Product team:

Allow Parent rows in report

Cheers,

Genevieve

Phil Wightman

Thanks @Genevieve P. will check them out