Skip to main content
Adobe Employee
July 19, 2023
Question

Conditionally show part of text in different color on report

  • July 19, 2023
  • 1 reply
  • 510 views

I have a project report that shows details from all of project issues. I have a custom field "Team Annual Plan" defined and it can have values either "Resources Available" or "No Resources". If resources are available, I would like to show issue name with its t-shirt size (custom field "T-Shirt Size" defined at issue level), indicate that the resources are available and in which that issue can be delivered (custom field "Projected Team Delivery Quarter" defined at issue level). If resources are not available, I would like to show issue name with its t-shirt size and indicate that resources are not available.

 

I use lists in this report with one of it's columns defined as follows: 

valueexpression=IF({DE:Team Annual Plan}="Resources available", concat(concat(concat(concat({name}, " -"), {DE:T-Shirt Size}), " - Resources Available - "), {DE:Projected Team Delivery Quarter}), IF({DE:Team Annual Plan}="No Resources", concat(concat(concat({name}, " -"), {DE:T-Shirt Size}), " - No Resources"), "" ))
listdelimiter=<p>
listmethod=nested(issues).lists
valueformat=HTML
displayname=Contributing Teams
textmode=true
type=iterate

 

This works as expected. This is a project report, so what you see below is one of the cell of a row in the report output.

Issue 1 - Small - Resources Available - 2023 Q3

Issue 2 - Medium - Resources Available - 2023 Q4

Issue 3 - Medium - No Resources

:

:

 

 

 

I would like to mark text "No Resources" in red. I do not want to mark rest of the text in red. 

 

 

Is that possible in Workfront text mode reporting?

 

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

1 reply

Kurt_Jones
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 28, 2023

ktrivedi, you can use the value parameter in textmode when doing things like shared cols and want to do some coloring, it allows you to apply html tags, like color, but it applies it to the whole field.  There is not a way in textmode to section up text for conditional formatting.

If my response answered your question, please mark it answered, so others can find the answer