Text Mode Formatting - Nested Tasks on a Project Report | Community
Skip to main content
K
KatelynnKe2
Level 2
June 4, 2025
Solved

Text Mode Formatting - Nested Tasks on a Project Report

  • June 4, 2025
  • 3 replies
  • 686 views

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.
Best answer by 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

3 replies

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
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

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

    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe Champion
    June 13, 2025

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

      Erika_Antkowiak
      Erika_AntkowiakAccepted solution
      Level 4
      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

        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        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!

        Kautuk Sahni
        Terms & ConditionsAccessibility statement

        Loading footer...