Children Parent Relationships on Reports

Sarah K
Sarah K ✭✭
edited 05/11/21 in Formulas and Functions

Hello,


I am trying to get my report to show the parent/child relationship so the owner can easily look at the dashboard and see what tasks are up coming. Currently my report looks like this so it appears all the task below are upcoming when really the highlighted in blue rows are the parent and the white rows are children.


This will make a huge difference in the way the report is viewed. Instead of 15 task approaching deadline it could show that 4 projects and 11 tasks are approaching deadline.

Screen Shot 2021-05-11 at 10.48.34 AM.png

I have also tried on the report the dashboard is pulling from to create a grouping see screenshot and it still isn't showing it on the dashboard correctly.

Screen Shot 2021-05-11 at 10.57.42 AM.png

Please Help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!