Skip to main content
KatelynnKe2
Level 2
June 4, 2025
Solved

Text Mode Formatting - Nested Tasks on a Project Report

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Erika_Antkowiak
Erika_AntkowiakAccepted solution
Adobe Champion
June 16, 2025

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 in thread

7 replies

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community Advisor
June 4, 2025

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-collections-report#limitations-of-a-collection-view

Translate
    OmahaOmaha
    Level 4
    June 13, 2025

    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.

    Translate
    skyehansen
    Adobe Champion and Community Advisor
    skyehansenAdobe Champion and Community Advisor
    June 13, 2025

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

    Translate
      Erika_Antkowiak
      Adobe Champion
      Erika_AntkowiakAdobe ChampionAccepted solution
      Adobe Champion
      June 16, 2025

      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

      Translate
        kautuk_sahni
        Adobe Employee
        kautuk_sahniAdobe Employee
        Adobe Employee
        July 16, 2025

        @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!

        Translate
        Kautuk Sahni
        Terms & ConditionsAccessibility statement

        Loading footer...