Report Design - How to show higher level task with late sub-tasks?

I am working on a couple of reports and they are working fine except I cannot see within the report the higher level task which has a sub task that is late.

For example:

Task

Sub Task - OK

Sub Task - Late

Sub Task - Future.

When I get the report to identify the late sub-task, I'd like to be able to see within the report the Task to which it belongs. Is this possible?

Thanks,

Donny

Find more posts tagged with

Reports

Project Management

Comments

Shaine Greenwood

Hi Donny,

There currently isn't a way to display hierarchical relationships in a report. When you have a moment, please submit a product enhancement request to let our Product team know that you're looking for that type of functionality.

As a potential workaround, you might consider adding another column to all of your source sheets that reflects information from the parent row, such as the data in the primary column. You can even automate this with a PARENT formula that looks at the primary column. More on PARENT here: https://help.smartsheet.com/function/parent

Sign in to join the conversation!

Quick Links

Trending discussions

Grouped reports with multi select dropdowns
This discussion was created from comments split from: Grouped Reports with multi-select dropdowns.
Automatically fill in data across sheets
I have a work plan in a sheet with a Checkbox column to denote where major decisions are required and a separate sheet working as a RAID log. Is there an equation or automation that would allow me to automatically in the RAID log based on the checkbox? Ideally I'd only want to fill in the relevant columns that are in the…
Automate sending out an email based upon an answer to a field
Hello, I have a dropdown in a column, and when one of four options are selected, I am looking to send an email out to a user. How do I set this up please?