Text Mode Formatting - Nested Tasks on a Project Report

[KatelynnKe2]

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.

[skyehansen]

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...

[OmahaOmaha]

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.

[skyehansen]

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

[KenHayes11]

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

[skyehansen]

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

[Erika_Antkowiak]

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