Best way to group rows in a report?


We use Smartsheet as a task tracker, adding subtasks and milestones as a child row on the sheet. I understand that Smartsheet does not currently recognize the parent / child relationship in reports but I was wondering if anyone had any suggestions on how to group tasks together within a report?

As it stands now, if I was to go into the report it looks something like this:

Task 1

Task 2

Task 3

Task 3 Sub-task 1

Task 3 Sub-task 2

Task 3 Sub-task 3

Task 2 Sub-task 1

Initially I was hoping that the auto numbering column would help things grouped but that does not seem to help when new rows are added. Does anyone have any thoughts?

Best Answer