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.

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.

Please Help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!