Creating reports making tasks into columns

Question

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?

VicSellers · Answer

Hi @karenne2 - 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 % Completelistdelimiter=
listmethod=nested(tasks).liststextmode=truetype=iteratevalueexpression=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 🙂

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded