Indent/Outdent Rows not showing on Reports and Dashboards

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

Sign in to vote!

Find more posts tagged with

On Wishlist

Comments

Mario W.

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

Rebecca 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.

Rebecca N

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).

Ken Armstrong

I know there are a bunch of work arounds for this, but life would be easier if you add the Include parent row when filtering. This is already a wonderful feature on a grid sheet filter so why not add to the reporting filters.

Leesa Y.

Agreed!!

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

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

Sandra Murray

Another basic request that will never get completed - 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.

Steven 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.

BGoupil

Hi, I had the same issue and I just decided to do conditional formatting accorting to row hierarchy. Now everybody know that dark blue is plan level, dark grey is a deliverable of the plan, mid-grey is a sub-deliverable and white is to dos. So even if there is no indent, we can follow. The only thing is, as there is no option to show parent lines like in the sheet filter, you need to create a formula to link childs to parents row in the report. Hope this helps

2023-10-04 14_25_55-99.0 Dashboard - Steering Committee - Smartsheet.com et 20 pages de plus - Trava.png

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.