Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Creating reports making tasks into columns

Avatar

Level 2

I'm new to creating custom reports and wondering if something is possible.  I have a project code with 3 tasks (QA, UM, Conf).  I want to make the project code the row (i know how to do that) and the 3 tasks into 3 columns with the resulting value in the column as either % complete or the word complete.  Is this possible?  If so, how do I do it?

Topics

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

5 Replies

Avatar

Community Advisor

Hi @KarenNe1 - I would give the below text mode a try on your project report! On the project report, create the three columns and then when copying the text mode below over, swap out where you see "QA" for the other values. As a note, this text mode assumes the task names are QA, UM, Conf exactly and not just containing those values.

 

displayname=QA % Complete
listdelimiter=<br>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({name}='QA',CONCAT({percentComplete},"%"))
valueformat=HTML

 

To let you know what is showing above to be able to do more investigating on it, the below is an example of collections reporting in Workfront so that you can add information from different levels of the object hierarchy.

 

Hope this helps

 

Avatar

Level 2

Thank you @VictoriaLinn 

I tried what you sent me and nothing is showing up.  Any thoughts?

Avatar

Community Advisor

Hi @KarenNe1 - Apologies, just seeing this!

Is the task name just "QA" or is it different than that?

Avatar

Level 2

Thank you @VictoriaLinn 

I tried what you sent me and nothing is showing up.  Any thoughts?