Displaying Row Hierarchy in Reports

I'm using Reports to show action items consolidated from 4 different sheets and assigned to individuals (separate report for each assignee).

I would like to maintain the row hierarchy in the report so that the parent row shows when one of its daughter rows is displayed as an uncompleted action item. I am maintaining the hierarchy now by adding a column on the sheet showing level and then including that in the Report (0 for parent, 1,2,3 for daughters). This helps to differentiate parent from child and as long as filters are not used, will maintain the proper hierarchical structure... but lacks the visual impact you can get from indented rows.

I realize that row hierarchy is not transferred to reports but is there a work around that could get me closer to the sheet structure and look for inclusion in a report.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!