Enhancement Request: Show indent levels of project tasks in reports

Dietrich Koch

I would really love to see the indent levels of tasks in report based on a project plan.

 

Today all tasks are shown left-aligned. With a rising count of tasks, subtasks and subtasks of a subtasks (and so on) it becomes confusing and unreadable. People not as deep into the plan as the project manager get totally lost very soon...

 

Switching on GanttView in the report does not help since parent tasks are not shown as roll-up but have the same style as tasks... :-(

 

Best

Dietrich

Kennedy Stomps

Hi Dietrich--displaying hierarchy in reporting is a feature that is currently on our enhancement request list and I've added your vote to support it. Thanks for your input!

Dietrich Koch

Kennedy,

 

thanks for that!

Daniel Stein

Hi Dietrich,

Thanks for the feedback! We are currently designing reporting enhancements that would:

- Show parent row information in a report.

- Allow grouping in reports.

- Allow summary calculations in reports.

J. Craig Williams

I'm eager to see these.

 

#3 will replace several of my solutions (and that's a good thing)

I'm going to have to put #1 through the wringers, as it could easily break things.

 

Either way, I'm looking forward to seeing them.

 

Craig

 

Dietrich Koch

Daniel,

 

that sounds realy great!

Can't wait to have it :-)

 

Best 

Dietrich

Dietrich Koch

Hi Daniel,

 

any news on this?

Maybe you have a timeframe for the reporting enhancements you mentioned?

 

Best

Dietrich

Daniel Stein

Hi Dietrich,

Sorry for the delay -- I think I missed the email notificatoin of your post.

 

With the recent formula engine improvements, there are a number of calculated columns that you can add to sheets that should be useful for your reports. For example:

 =COUNT(ANCESTORS()) calculates the hierarchy level

 =JOIN(ANCESTORS([primary cell in this row]), " > ") displays the complete parent hierarchy information.

 

With these formulas, you can display parent row information in a report, or filter rows from a particular sheet hierarchy level.

 

We don't yet have an ETA for the grouping and summary calculation features in reports, and I don't expect we'll deliver these until next year.

 

Hope this helps!

Daniel

Anne Marie O'Byrne

Hi,

 

      Do you have any update on when this feature will be avialable? 

 

Thanks,

 

 

Shaine Greenwood

Hi Anne,

 

We don't have a timeframe for when these reporting improvements will be added to Smartsheet but I've got your vote down for this on our enhancement request list for further consideration.

hdorath

Hello Smartsheet team,

 

Do you have any updates?

 

this is a very critical issue for me and my organization.

 

thank you!

 

Cheers,

Alvin Ang

+1, would be great to show indentation in reports..otherwise, everything is all jumbled together..

Mooz

Hi, 

Any updates on when indentations & "include parent" options should be available into the reports? 

That would be awesome! 

Thanks

droseman

This would be very helpful to us as well - any update on timing?

Maggie Quijada

I agree, an update on timing is very important. Not having this feature makes the product almost useless as it cannot be viewed accurately.

Daniel Stein

Thanks for checking in. We are currently working on infrastructure improvements to reporting that will improve reporting performance and pave the way for reporting feature enhancements. We don't yet have a specific timeline to share for the feature enhancements, but in the meantime we are always interested to hear about your scenarios, so please keep the feedback coming. The more detailed you can be about how you'd like to use reports, the better.

In the meantime, as mentioned above you can add calculated columns to your sheets in order to  display hierarchy information in your reports. Here are a couple of useful formulas for this purpose:

 =COUNT(ANCESTORS()) calculates the hierarchy level

 =JOIN(ANCESTORS([primary cell in this row]), " > ") displays the complete parent hierarchy information.

Thanks,

Daniel