Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Creating a custom column in a project report that displays all active parent tasks

Avatar

Level 2

Hi All,

 

I'm trying to create a custom column on a project report that will display all active parent tasks in a project, along with the % complete. How would I go about creating a text code that would generate this for me?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I have several project reports that do variations of this. I call them hot sheets. You can play around with this if you'd like.

 

displayname=Parent Tasks
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({percentComplete}<100 && {canStart}="true" && {numberOfChildren}>0,CONCAT({name}," | ",CONCAT({percentComplete},"%")," | ",{plannedCompletionDate}," | ",{progressStatus}))
valueformat=HTML




View solution in original post

5 Replies

Avatar

Level 5

Any reason you can't do this as a Task-Level Report and then just group by Project? It would be very simple as a Task-Level report (no Text-Mode needed).

Avatar

Level 2

Its really a preference for the team.  I would prefer to do it the normal way, but I wanted to see if it was possible to do it in a task report maybe using nesting text or something.

Avatar

Level 5

Give this a try (on a Task report). This should build a bulleted list of any tasks that have a status of In Progress and have at least 1 child task. The list will show the name of the task and the % complete of that task.

displayname=Parent Task - % Complete
linkedname=tasks
listdelimiter=<div>
listmethod=nested(tasks).lists
namekey=view.relatedcolumn
textmode=true
type=iterate
valueexpression=IF({numberOfChildren}>=1,IF({status}="INP",CONCAT(" • ",{name}," - ",{percentComplete},"%"),""),"")
valueformat=HTML

Avatar

Correct answer by
Community Advisor

I have several project reports that do variations of this. I call them hot sheets. You can play around with this if you'd like.

 

displayname=Parent Tasks
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({percentComplete}<100 && {canStart}="true" && {numberOfChildren}>0,CONCAT({name}," | ",CONCAT({percentComplete},"%")," | ",{plannedCompletionDate}," | ",{progressStatus}))
valueformat=HTML




Avatar

Level 2

Thanks! this helped out a lot. Going to change the progress status to display words instead of status initials.