Creating reports making tasks into columns

[KarenNe1]

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?

[VictoriaLinn]

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

[KarenNe1]

Thank you @VictoriaLinn 

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

[VictoriaLinn]

Hi @KarenNe1 - Apologies, just seeing this!

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

[KarenNe1]

The task name is just "QA".

[KarenNe1]

Thank you @VictoriaLinn 

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