How do I show child AND PARENT rows in report?

Sydney Colbert

I would like some help on how to show parent and child rows in a smartsheet report.

See this loom recording for more context: https://www.loom.com/share/b55c7ed651994c2d8cfbbf1ed0d04665

Andrée Starå

Hi @Sydney Colbert

I hope you're well and safe!

I'd recommend adding so-called helper columns.

Parent

=PARENT([Mailing Name]@row)

Hierarchy

=JOIN(ANCESTORS([Mailing Name]@row), " / ")

Would that work/help?

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!