I believe this idea has already been submitted, but please add my vote. We use Smartsheet for project management, and need to share project schedules through reports and dashboards, but with the row hierarchy flattened the reports become incomprehensible.
Same issue for me, another vote that is.
Reports don't visually display task indentations from the source sheet. This makes it impossible to know which rows are sub-tasks, which is really important when you want a rollup report that shows major milestones along with task groups that form the critical path.
I've sort of gotten around this by applying consistent color formats to header rows based on their WBS level, but it's still not ideal.
I have done a work around as well by using a dropdown column and naming the header row "header" then use "header" as one of my filters in the reports as well as color coding them.
I agree - There are a lot of opportunities from improving reporting, and this is one of them. The other is utilizing the summarized data for metrics and graphs on dashboards. Would love to see reports bring together content in the way they do with more formatting and presenting options, while also utilizing the data in the same way we would on grid sheets.
I would like to know why updating reports is so difficult for your programmers. This is a major downfall for what I use Smartsheet for. Please someone tell me, I asked before and have not gotten any responses.
Yes, it would be great if the parent/child feature could be used by people who access a dashboard that is linked to a report/sheet that has this feature enabled!
The workarounds assume that the data in the sheet is static. I work with a number of less experienced users who add data to their sheets but they are not going to be adding parent/child indicators at each row. This is so hard to manage for a very simple issue.
Recommendation:
When displaying the tasks on the report, include the level about it. Allow user to indicate how many levels above the task to include. 1 is the parent, 2 is the grandparent, 3 is the great-grandparent.
This is really,really needed. Please escalate. thank you