Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Level 10

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