Issue Status Names Instead of Status Value

[ChrisFl]

I have a calculated field on my report that is looking for issues that were opened during the last reporting period, regardless of current status. I have the output to concat the issue name and status, but I'm getting the status value instead of the status name. Any ideas how to get the status name?

My valueexpression is basically: valueexpression=IF(<verylongwindedstatement>,CONCAT("‚ñ∫ ",{name}," - ",{status})," ")

My return is showing as: <issuename> - INP or <issuename> - CLS

And what I want is: <issuename> - In Progress or <issuename> - Closed

[AnthonyIm · Accepted solution]

Curious if someone has a better solution. I go through and put IF statements for my statuses (leaving New for the end)

valueexpression=IF(<verylongwindedstatement>,CONCAT("‚ñ∫ ",{name}," - ",IF({status}="INP","In Progress",IF({status}="CLS","Closed",IF({status}="CAN","Cancelled",IF({status}="ONH","On Hold","New"))))),"")

[ChrisFl]

Yup, that worked perfectly. Thanks a ton!

[ChrisFl]

Ooh, I didn't think of that. That should give me what I want, let me combine it with my valueexpression and see what it looks like.

[Kundanism]

Hei @Chris Flynn‚

Is it possible to share the whole text code for the above?

Would like to test in one of our report?

Kind regards,

Kundan.

[ChrisFl]

Of course, I've placed it below.

Just to explain what I'm trying to accomplish, it's for a column that would capture any issued open at any time during our status period (a week back from current week) and the current status of the issue. We also store status reports and change requests as issues, so there's portions there to exclude those from the list (since they're captured elsewhere). And there's some customization to our status names, so that's reflected too.

The intent is to capture any issue from last week, including closed ones, in order to reflect issue work and issue resolution the PM did during the last week.

I'm not the best with the code, so it might be a little clunky.

displayname=Issues This Period / Status

listdelimiter=<p>

listmethod=nested(project.issues).lists

textmode=true

type=iterate

valueexpression=IF({plannedStartDate}<=$$TODAYbw&&{actualCompletionDate}>=$$TODAYbw-1w&&{actualCompletionDate}<$$TODAYb&&{DE:Is this a status report?}!="yes"||{plannedStartDate}<=$$TODAYbw&&ISBLANK({actualCompletionDate})&&{DE:Is this a status report?}!="yes",CONCAT("‚ñ∫ ",{name}," - ",IF({status}="INP","In Progress",IF({status}="CLS","Resolved",IF({status}="CWR","Closed / Won't Resolve",IF({status}="ONH","On Hold",IF({status}="ROP","Reopened","New"))))))," ")

valueformat=HTML