Adding task status to a project report | Community
Skip to main content
G
GeorgeBu
December 12, 2020
Question

Adding task status to a project report

  • December 12, 2020
  • 1 reply
  • 841 views

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.

1 reply

R
Community Advisor
Richard_Le_Community Advisor
Community Advisor
December 13, 2020

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
    Kundanism
    December 14, 2020

    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

    R
    Community Advisor
    Richard_Le_Community Advisor
    Community Advisor
    December 14, 2020

    Hi Kundan,

    Yes that's right.

    Best Regards,

    Rich,

      Terms & ConditionsAccessibility statement

      Loading footer...