Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards.
SOLVED

Text Mode Formatting - Nested Tasks on a Project Report

Avatar

Level 2

Hi! I am running into an issue with text mode rules for a project report that references nested tasks. 

 

listmethod=nested(tasks).lists

 

Is it possible to apply a conditional formatting within this list method? Essentially, if there is no matching task I want the box to be greyed or have an icon. However when I apply the text mode coding that works in a traditional column, the text mode column shows the coding in plain text.

1 Accepted Solution

Avatar

Correct answer by
Level 4

Hi @KenHayes11! There are a few different ways to have a cell on a report change color, and I'm highlighting my recommendations below.

 

  1. Advanced Options [Recommended]: Select a column that you want to color code > click the "Advanced Options" link on the right side of the page > click the "Add Column Rule" and choose if you want a different text color for your cells, a different background color + the column rule that will dictate when a cells background or text color will change.
    • Note - Once a rule has been created for a column you can switch over to text mode to see what is needed to format the cell manually in text mode. I've provided an example below.
  2. Text Mode: The following should be included if you want your cell to turn red if the planned completion date is past due (less than today).
    • styledef.case.0.comparison.leftmethod=plannedCompletionDate

      styledef.case.0.comparison.lefttext=plannedCompletionDate

      styledef.case.0.comparison.operator=lt

      styledef.case.0.comparison.operatortype=date

      styledef.case.0.comparison.righttext=$$TODAY

      styledef.case.0.comparison.icon=false

      styledef.case.0.comparison.isrowcase=false

      styledef.case.0.comparison.trueproperty.0.name=bgcolor

      styledef.case.0.comparison.trueproperty.0.value=EAC6C9

Let me know how this goes and if you have any questions. 

 

Best,

E

View solution in original post

7 Replies

Avatar

Community Advisor

Hi, please refer to this section (limitations of a collection view), which states that you cannot apply conditional formatting to a collection view.

 

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/reference-col...

Avatar

Level 4

Hi All,  has anyone ever attempted to add color coding to a nested task field on a project report?  I want to add color to the cell in the report if the field is not blank.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

Avatar

Community Advisor

this seems quite similar to a previous question, so I'm merging your question into it.

Avatar

Level 1

Is there a way that if there's 'overdue tasks' on my report, that it will change the background of that cell to red?  I can't seem to figure out the rule to get this to work....

 

displayname=Overdue Tasks

listdelimiter=<p>

listmethod=nested(tasks).lists

type=iterate

usewidths=true

valueexpression=IF({numberOfChildren}=0 && ISBLANK({actualCompletionDate}) && DATEDIFF({plannedCompletionDate}, $$TODAY)<0,CONCAT({plannedCompletionDate}," - ",{name}," - ",{assignedTo}),"")

valueformat=HTML

width=300

Avatar

Community Advisor

I'm merging this question into a similar post, as the answer probably applies.

Avatar

Correct answer by
Level 4

Hi @KenHayes11! There are a few different ways to have a cell on a report change color, and I'm highlighting my recommendations below.

 

  1. Advanced Options [Recommended]: Select a column that you want to color code > click the "Advanced Options" link on the right side of the page > click the "Add Column Rule" and choose if you want a different text color for your cells, a different background color + the column rule that will dictate when a cells background or text color will change.
    • Note - Once a rule has been created for a column you can switch over to text mode to see what is needed to format the cell manually in text mode. I've provided an example below.
  2. Text Mode: The following should be included if you want your cell to turn red if the planned completion date is past due (less than today).
    • styledef.case.0.comparison.leftmethod=plannedCompletionDate

      styledef.case.0.comparison.lefttext=plannedCompletionDate

      styledef.case.0.comparison.operator=lt

      styledef.case.0.comparison.operatortype=date

      styledef.case.0.comparison.righttext=$$TODAY

      styledef.case.0.comparison.icon=false

      styledef.case.0.comparison.isrowcase=false

      styledef.case.0.comparison.trueproperty.0.name=bgcolor

      styledef.case.0.comparison.trueproperty.0.value=EAC6C9

Let me know how this goes and if you have any questions. 

 

Best,

E

Avatar

Administrator

@KatelynnKe2 Just checking in — were you able to resolve your issue?
We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!



Kautuk Sahni