Custom Column to state if a task is a parent task

Forum|Forum|1 year ago
April 25, 2024
2 replies
831 views

When using the "Parent" Field in a Task View it displays the project name when the task is a parent task. We're aiming to display "Parent Task" when the "Parent" field matches the project name, indicating it is a parent task. Otherwise, it should display the task name, indicating it's a child task. Here's is the calculated column formula I've been trying but is not working:

displayname=Parent Task
textmode=true
valueexpression=IF({backlogParent}={project:name},"Parent Task",{backlogParent})
valueformat=HTML

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

KristenS_WF

Level 6

I can't get backlogParent to work in a valueexpression (only as valuefield), but does this get what you want?

displayname=Parent Task
textmode=true
valueexpression=IF({numberOfChildren}>0,"Parent Task",{parent}.{name})
valueformat=HTML

J

JohnMiAuthor

Level 3

Thank you, but that does not work either. I also tried:

displayname=Parent Task

textmode=true
valueexpression=IF({backlogParent}={project:name},"Parent Task",{backlogParent})
valueformat=HTML

NicholeVargas

Adobe Employee

@johnmi I'm curious as to how your project timelines are structured - are all tasks within the project timeline organized by a parent-child relationship? Or do you have standalone tasks with no parent and no children (meaning the real parent task is the project name)?

If the first option, then you can use the following:

displayname=Parent/Child Tasks
textmode=true
valueexpression=IF({numberOfChildren}>0,"Parent Task",{name})
valueformat=HTML

If the latter option, how would you want those displayed in your report? Because they have no child tasks, they aren't really a parent task, so the project name would be the parent.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded