Grand Parent or Parent's Parent Task to show in own column on a Report

Question

Hi All! Hoping someone can help me figure out the right Text Mode configuration to pull in a task's Grand Parent name into it's own separate column. Within our projects many tasks have overarching Grand Parent tasks, then a Parent task, then a specific task assigned to a user. What I need is a way to include what that Grand Parent task name is on an Hour Report.

I figured out how to group by this information, but the particular report I am working on currently needs to have this information in a separate column.

Any ideas on this would be really appreciated!!

skyehansen · Accepted Answer

I think it may be because it's on an Hour report, and not a Task report as I previously said (my mistake!). I'm working on a report someone else created, but if I can't get it to work on the hour report I may just create a new report as a better work around. Thanks again!

try this:

displayname=grandparent
linkedname=task
namekey=view.relatedcolumn
namekeyargkey.0=task
namekeyargkey.1=parent:parent:name
querysort=task:parent:parent:name
textmode=true
valuefield=task:parent:parent:name
valueformat=HTML

All I do is take the Task | ParentID field from standard mode, change this to text mode, and change out the "ID" part for ":parent:name"

KristenS_WF · Answer

See if this works for you. displayname=Grandparent Task Nametextmode=truevalueexpression={parent}.{parent}.{name}valueformat=HTML

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded