Adding task status to a project report | Community
Skip to main content
GeorgeBu
New Participant
Dec 12, 2020 3:51 AM UTC
Question

Adding task status to a project report

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

Richard_Le_
New Participant
Dec 13, 2020 10:08 PM UTC

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.

Translate
    Kundanism
    Kundanism
    Level 10
    Dec 14, 2020 12:09 PM UTC

    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

    Translate
    Richard_Le_
    New Participant
    Dec 14, 2020 3:48 PM UTC

    Hi Kundan,

    Yes that's right.

    Best Regards,

    Rich,

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...