Hi Rhonda,
Thank you for posting your idea.
The Task Name (Full Path) column is currently a consolidated column. However, it is possible to break apart individual task levels into separate columns using a custom formula in the Task report.
I've included a sample formula for pulling out the 2nd level task name from the Task hierarchy. Additional Task level names can similarly be extracted from the full path by extending the same logic.
IF (Find (Mid (TaskHierarchyName, Find (TaskHierarchyName, "/") + 1, Len (TaskHierarchyName) - (Find (TaskHierarchyName, "/") +1) ), "/") = -1, "", Left (Mid (TaskHierarchyName, Find (TaskHierarchyName, "/") + 1, Len (TaskHierarchyName) - (Find (TaskHierarchyName, "/") +1) ) , Find (Mid (TaskHierarchyName, Find (TaskHierarchyName, "/") + 1, Len (TaskHierarchyName) - (Find (TaskHierarchyName, "/") +1) ), "/")) )
If you'd like further help in setting this up in your report, please let us know and one of our Support Specialists will get in touch with you.
Also, we recently added a new column to the Task report - 'Total Project Hours'. This column shows the overall total hours logged against the project for all tasks, all dates and by all users.
Hope this helps.
Thank you,
Naveen