Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Adding task status to a project report

Avatar

Level 1

Hello all...

Developing a project report and would like to add a column with the task's status. Using the following text mode, but its pulling the status key rather than the task status name.

displayname=Creative Proof Status

listdelimiter=<br>

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF(CONTAINS("Upload Creative Proof",{name}),{status name})

valueformat=HTML

Thoughts? Suggestions?

Thanks!

Topics

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

4 Replies

Avatar

Community Advisor

Hi George,

You will need to map the status name to the status key as part of your value expression. So your code would look something like the following:

displayname=Creative Proof Status

listdelimiter=<br>

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF(CONTAINS("Upload Creative Proof",{name}),IF({status}="CPL","Complete",IF({status}="NEW","New",IF({status}="INP","In Progress"))))

valueformat=HTML

Hope that helps!

Best Regards,

Rich.

Avatar

Level 10

Sorry to ask @Richard Leek‚ , just trying to understand in simple, appreciate your help in this regard.

Is it the process to create report is like this way;

Go to Reporting >>Reports>>Select "Project Report">>Column(Text mode"+add above text code?

Mvh

Kundan

Avatar

Community Advisor

Hi Kundan,

Yes that's right.

Best Regards,

Rich,

Avatar

Level 1
Thanks Rich. This worked perfectly.