Adding task status to a project report

[GeorgeBu]

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!

[Richard_Le_]

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.

[Kundanism]

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

[Richard_Le_]

Hi Kundan,

Yes that's right.

Best Regards,

Rich,

[GeorgeBu]

Thanks Rich. This worked perfectly.