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 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?