Best way to group rows in a report?

Hello,

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

Answers