Collections Report Conditional Formating | Community
Skip to main content
Tammy_Hall-Johnson
Tammy_Hall-Johnson
January 21, 2023
Solved

Collections Report Conditional Formating

  • January 21, 2023
  • 2 replies
  • 849 views

My user has a collections report that they want the Task Status of CPL to show in Green.  My code is below but I can't get it to work!  Help!  Something in the back of my head is saying I actually can't reference the collection object in the conditional formating.

 

displayname=D
linkedname=direct
listdelimiter=<div>
listmethod=nested(tasks).lists
namekey=D
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=task:status
styledef.case.0.comparison.lefttext=task:status
styledef.case.0.comparison.operator=in
styledef.case.0.comparison.operatortype=string
styledef.case.0.comparison.righttext=CPL
styledef.case.0.comparison.trueproperty.0.name=bgcolor
styledef.case.0.comparison.trueproperty.0.value=def6e2
styledef.case.0.comparison.truetext=
textmode=true
type=iterate
valueexpression=IF({milestoneID}="628fe05b003225fa2f328bf990bd9a27",{status},"")
valueformat=

    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 Rafal_Bainie

    As noted in the documentation:

    You cannot conditionally format a column which contains a valueexpression line of code. Instead, you can add a Calculated Custom Field to a Custom Form and associate it with the objects you are displaying in the report. Then, you can conditionally format the columns displaying this field.


    https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/use-conditional-formatting-text-mode.html?lang=en

    2 replies

    MATTHEW450
    MATTHEW450
    January 21, 2023

    I don't think this is possible. Using conditional formatting will always format everything within a column. To isolate elements you need to wrap elements in HTML using spacing columns. But when it comes to a collection, you cannot wrap individual elements because they can't be isolated

      theffernan
      theffernan
      January 22, 2023

      Could you set the valueformat= to HTML and put font color tags around CPL in this line styledef.case.0.comparison.righttext=CPL?

      Rafal_Bainie
      Community Advisor
      Rafal_BainieCommunity AdvisorAccepted solution
      Community Advisor
      January 24, 2023

      As noted in the documentation:

      You cannot conditionally format a column which contains a valueexpression line of code. Instead, you can add a Calculated Custom Field to a Custom Form and associate it with the objects you are displaying in the report. Then, you can conditionally format the columns displaying this field.


      https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/use-conditional-formatting-text-mode.html?lang=en

        Terms & ConditionsAccessibility statement

        Loading footer...