Indent/Outdent Rows not showing on Reports and Dashboards

shanease

I have a Project Schedule "Sheet" that has several parent and child rows. When I created a "Report" for this same sheet, I noticed that the parent/child rows are not showing on the "Report". For example, the report is not allowing me to see which rows are indented/outdented. It would be very helpful to have a way that the indent/outdent feature is made available on Reports and Dashboards. I would prefer not to use a WBS system where I am numbering all the rows such as 1, 1.1, 1.2, etc. Also, I have already tried to bold and highlight certain rows. I ask because I would like the report to show on my dashboard with a list of all the parent/child rows accordingly. Thank you!

Sheet view.jpg

Report Issue screenshot.jpg

Dashboard Issue.jpg

Mario W.

It would be great if this could be realized. I have the same issue/request.

丽贝卡·N

I would like to be able to create a report that shows the task under there respected parent and child just like I see the hierarchy in the sheet.

Adrian Mandile CHESS

Hi@Rebecca N,

You may have already tried this, but one way to achieve what you are after is to add a couple of 'helper' columns next to your Primary Column that return that row's Parent and Grandparent values.

Then in the Report, use the Group option to group the records/rows first by the Grandparent column, then second by the Parent column.

丽贝卡·N

Hi @Rebecca N<\/a>,<\/p>

You may have already tried this, but one way to achieve what you are after is to add a couple of 'helper' columns next to your Primary Column that return that row's Parent and Grandparent values. <\/p>

Then in the Report, use the Group option to group the records\/rows first by the Grandparent column, then second by the Parent column.<\/p>","bodyRaw":"[{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"Rebecca N\",\"userID\":156027}}},{\"insert\":\",\\nYou may have already tried this, but one way to achieve what you are after is to add a couple of 'helper' columns next to your Primary Column that return that row's Parent and Grandparent values. \\nThen in the Report, use the Group option to group the records\\\/rows first by the Grandparent column, then second by the Parent column.\\n\"}]","format":"rich","dateInserted":"2023-02-07T02:24:20+00:00","insertUser":{"userID":0,"name":"unknown","url":"https:\/\/community.smartsheet.com\/profile\/unknown","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-29T14:55:48+00:00","banned":0,"private":false},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/360838#Comment_360838","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/360838#Comment_360838

I did, but then it puts all parents together as one header and doesn't look good. Thanks!

detsh

Within reports, when in Gantt view, would like to have the ability to see the summary of the gantt chart view (start/end dates) for all of the items within the Group. So see the parent level instead of just the children level at the top (group level).

JessieSmall

Is this anything that has been addressed? Having the same issue with a report not pulling data from the second parent row on the sheet.

shanease

@JessieSmallUnfortunately this still has not been addressed. I submitted a help ticket a while ago on the issue as well.@helpaccount@Help

Sandra Murray

另一个基本要求,永远不会完成d - how many years Smartsheet, do you have a count down?

Paul Hazelhurst

Currently when producing a report with the source being a schedule, the report doesn't maintain parent, child relationship. All tasks become standalone. So again not quite reflecting the schedule source in true form so provides a slights skewed view.

史蒂文Munsey

Requesting the ability to outdent / indent rows in a report, reflecting what may already be in a worksheet (like in a project schedule / Gantt view). All of our project dashboards have report widgets that show the schedule and it would look more visually appealing if the child rows were indented in the widget as on the worksheet.

ApolloEndo

Has anyone created a work-around for this yet? Would love to see some examples!

BDuplain

I have run into this same issue. Reporting is such an important part of what we present to our senior leaders (also our budget decision makers), so it is vital that reporting shows the parent/children relationship.