Assignment report - adding conditional formatting to shared columns | Community
Skip to main content
RhondaGayleTX
RhondaGayleTX
Level 5
February 21, 2023
Solved

Assignment report - adding conditional formatting to shared columns

  • February 21, 2023
  • 2 replies
  • 979 views

Hi, I have an assignment report where I have added conditional formatting to the Task Planned Completion Date and the Issue Planned Completion date columns. I then merged the two columns using sharecol=true, however, most of the conditional formatting was lost. 

 

I noticed that styledef.case.0.comparison.righttext=$$TODAY was present without styledef.case.0.comparison.rightmethod=  present in the code to go with it. 

 

I tried adding the line in according to the articles I found that reference other types of reports, however this does not seem to work with the assignment report. Has anyone else experienced this or found a solution?


Here is my text:

column.10.styledef.case.0.comparison.lefttext=opTask:plannedCompletionDate
column.10.styledef.case.0.comparison.truetext=
column.10.styledef.case.0.comparison.leftmethod=opTask:plannedCompletionDate
column.10.styledef.case.0.comparison.operatortype=date
column.10.styledef.case.0.comparison.trueproperty.0.value=bold
column.10.styledef.case.0.comparison.trueproperty.0.name=fontstyle
column.10.styledef.case.0.comparison.trueproperty.1.value=d30519
column.10.styledef.case.0.comparison.trueproperty.1.name=textcolor
column.10.styledef.case.0.comparison.righttext=$$TODAY
column.10.styledef.case.0.comparison.operator=lt
column.10.styledef.case.0.comparison.icon=false
column.10.styledef.case.0.comparison.rightmethod=opTask:plannedCompletionDate
column.10.styledef.case.1.comparison.trueproperty.0.name=fontstyle
column.10.styledef.case.1.comparison.trueproperty.0.value=bold
column.10.styledef.case.1.comparison.trueproperty.1.name=textcolor
column.10.styledef.case.1.comparison.trueproperty.1.value=03a219
column.10.styledef.case.1.comparison.leftmethod=opTask:plannedCompletionDate
column.10.styledef.case.1.comparison.operator=eq
column.10.styledef.case.1.comparison.lefttext=opTask:plannedCompletionDate
column.10.styledef.case.1.comparison.truetext=
column.10.styledef.case.1.comparison.operatortype=date
column.10.styledef.case.1.comparison.righttext=$$TODAY
column.10.styledef.case.1.comparison.rightmethod=opTask:plannedCompletionDate
column.10.styledef.case.1.comparison.icon=false
column.10.valueformat=atDate
column.10.sharecol=true
column.10.sortType=asc
column.10.namekey=view.relatedcolumn
column.10.textmode=true
column.10.querysort=opTask:plannedCompletionDate
column.10.valuefield=opTask:plannedCompletionDate
column.10.linkedname=opTask
column.10.shortview=true
column.10.sortOrder=1
column.10.displayname=PLN Due Date
column.10.namekeyargkey.0=opTask
column.10.namekeyargkey.1=plannedCompletionDate
column.11.valuefield=task:plannedCompletionDate
column.11.querysort=task:plannedCompletionDate
column.11.valueformat=atDate
column.11.displayname=
column.11.linkedname=task
column.11.namekey=view.relatedcolumn
column.11.namekeyargkey.0=task
column.11.namekeyargkey.1=plannedCompletionDate
column.11.styledef.case.0.comparison.leftmethod=task:plannedCompletionDate
column.11.styledef.case.0.comparison.lefttext=task:plannedCompletionDate
column.11.styledef.case.0.comparison.righttext=$$TODAY
column.11.styledef.case.0.comparison.rightmethod=task:plannedCompletionDate
column.11.styledef.case.0.comparison.operator=lt
column.11.styledef.case.0.comparison.operatortype=date
column.11.styledef.case.0.comparison.icon=false
column.11.styledef.case.0.comparison.truetext=
column.11.styledef.case.0.comparison.trueproperty.0.name=fontstyle
column.11.styledef.case.0.comparison.trueproperty.0.value=bold
column.11.styledef.case.0.comparison.trueproperty.1.name=textcolor
column.11.styledef.case.0.comparison.trueproperty.1.value=d30519
column.11.styledef.case.1.comparison.leftmethod=task:plannedCompletionDate
column.11.styledef.case.1.comparison.lefttext=task:plannedCompletionDate
column.11.styledef.case.1.comparison.righttext=$$TODAY
column.11.styledef.case.1.comparison.rightmethod=task:plannedCompletionDate
column.11.styledef.case.1.comparison.operator=eq
column.11.styledef.case.1.comparison.operatortype=date
column.11.styledef.case.1.comparison.icon=false
column.11.styledef.case.1.comparison.truetext=
column.11.styledef.case.1.comparison.trueproperty.0.name=fontstyle
column.11.styledef.case.1.comparison.trueproperty.0.value=bold
column.11.styledef.case.1.comparison.trueproperty.1.name=textcolor
column.11.styledef.case.1.comparison.trueproperty.1.value=03a219

I also tried pasting the text into a text file to check gremlins / carriage returns and then pasted back to Workfront, just in case that was causing something to fail.

Any advice or comforting words would be appreciated! 😁
    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 Madalyn_Destafney

    Hi there, I actually just happened to make an assignment report this week with issue/task planned completion merged along with conditional formatting to show if it's 'less than today' it shows red. Text mode below. Here's the thing about conditional formatting on columns that you then share with other columns. Oddly, you have to have the columns with the formatting directly to the column you want to share with, otherwise if you reverse it your formatting goes away. 

    Here is the text mode for my combined task/issues planned completion date, note my report filter is only for assignments that are incomplete and due $$TODAY or earlier. If this helps you please mark complete to help others : ) I can also send you the combined assignment columns if needed (to show tasks/issues assignments in 1 column)!

    column.6.displayname=Planned Completion
    column.6.linkedname=direct
    column.6.namekey=date
    column.6.querysort=date
    column.6.sharecol=true
    column.6.styledef.case.0.comparison.icon=false
    column.6.styledef.case.0.comparison.leftmethod=task:plannedCompletionDate
    column.6.styledef.case.0.comparison.lefttext=task:plannedCompletionDate
    column.6.styledef.case.0.comparison.operator=lte
    column.6.styledef.case.0.comparison.operatortype=date
    column.6.styledef.case.0.comparison.righttext=$$TODAY
    column.6.styledef.case.0.comparison.trueproperty.0.name=textcolor
    column.6.styledef.case.0.comparison.trueproperty.0.value=000000
    column.6.styledef.case.0.comparison.trueproperty.1.name=bgcolor
    column.6.styledef.case.0.comparison.trueproperty.1.value=eac6c9
    column.6.styledef.case.0.comparison.truetext=
    column.6.styledef.case.1.comparison.icon=false
    column.6.styledef.case.1.comparison.leftmethod=opTask:plannedCompletionDate
    column.6.styledef.case.1.comparison.lefttext=opTask:plannedCompletionDate
    column.6.styledef.case.1.comparison.operator=lte
    column.6.styledef.case.1.comparison.operatortype=date
    column.6.styledef.case.1.comparison.righttext=$$TODAY
    column.6.styledef.case.1.comparison.trueproperty.0.name=textcolor
    column.6.styledef.case.1.comparison.trueproperty.0.value=000000
    column.6.styledef.case.1.comparison.trueproperty.1.name=bgcolor
    column.6.styledef.case.1.comparison.trueproperty.1.value=eac6c9
    column.6.styledef.case.1.comparison.truetext=
    column.6.textmode=true
    column.6.usewidths=true
    column.6.valuefield=date
    column.6.valueformat=
    column.6.width=65
    column.7.displayname=Planned Completion Date
    column.7.styledef.case.0.comparison.icon=false
    column.7.styledef.case.0.comparison.leftmethod=plannedCompletionDate
    column.7.styledef.case.0.comparison.lefttext=plannedCompletionDate
    column.7.styledef.case.0.comparison.operator=lt
    column.7.styledef.case.0.comparison.operatortype=date
    column.7.styledef.case.0.comparison.righttext=$$TODAY
    column.7.styledef.case.0.comparison.trueproperty.0.name=textcolor
    column.7.styledef.case.0.comparison.trueproperty.0.value=d30519
    column.7.styledef.case.0.comparison.trueproperty.1.name=bgcolor
    column.7.styledef.case.0.comparison.trueproperty.1.value=eac6c9
    column.7.styledef.case.0.comparison.truetext=
    column.7.styledef.case.1.comparison.icon=false
    column.7.styledef.case.1.comparison.leftmethod=opTask:plannedCompletionDate
    column.7.styledef.case.1.comparison.lefttext=opTask:plannedCompletionDate
    column.7.styledef.case.1.comparison.operator=lt
    column.7.styledef.case.1.comparison.operatortype=date
    column.7.styledef.case.1.comparison.righttext=$$TODAY
    column.7.styledef.case.1.comparison.trueproperty.0.name=textcolor
    column.7.styledef.case.1.comparison.trueproperty.0.value=d30519
    column.7.styledef.case.1.comparison.trueproperty.1.name=bgcolor
    column.7.styledef.case.1.comparison.trueproperty.1.value=eac6c9
    column.7.styledef.case.1.comparison.truetext=
    column.7.textmode=true
    column.7.usewidths=true
    column.7.valueexpression=IF(ISBLANK({task}.{name}),{opTask}.{plannedCompletionDate},{task}.{plannedCompletionDate})
    column.7.valueformat=HTML
    column.7.width=65






    2 replies

    Madalyn_Destafney
    Community Advisor
    Madalyn_DestafneyCommunity AdvisorAccepted solution
    Community Advisor
    March 16, 2023

    Hi there, I actually just happened to make an assignment report this week with issue/task planned completion merged along with conditional formatting to show if it's 'less than today' it shows red. Text mode below. Here's the thing about conditional formatting on columns that you then share with other columns. Oddly, you have to have the columns with the formatting directly to the column you want to share with, otherwise if you reverse it your formatting goes away. 

    Here is the text mode for my combined task/issues planned completion date, note my report filter is only for assignments that are incomplete and due $$TODAY or earlier. If this helps you please mark complete to help others : ) I can also send you the combined assignment columns if needed (to show tasks/issues assignments in 1 column)!

    column.6.displayname=Planned Completion
    column.6.linkedname=direct
    column.6.namekey=date
    column.6.querysort=date
    column.6.sharecol=true
    column.6.styledef.case.0.comparison.icon=false
    column.6.styledef.case.0.comparison.leftmethod=task:plannedCompletionDate
    column.6.styledef.case.0.comparison.lefttext=task:plannedCompletionDate
    column.6.styledef.case.0.comparison.operator=lte
    column.6.styledef.case.0.comparison.operatortype=date
    column.6.styledef.case.0.comparison.righttext=$$TODAY
    column.6.styledef.case.0.comparison.trueproperty.0.name=textcolor
    column.6.styledef.case.0.comparison.trueproperty.0.value=000000
    column.6.styledef.case.0.comparison.trueproperty.1.name=bgcolor
    column.6.styledef.case.0.comparison.trueproperty.1.value=eac6c9
    column.6.styledef.case.0.comparison.truetext=
    column.6.styledef.case.1.comparison.icon=false
    column.6.styledef.case.1.comparison.leftmethod=opTask:plannedCompletionDate
    column.6.styledef.case.1.comparison.lefttext=opTask:plannedCompletionDate
    column.6.styledef.case.1.comparison.operator=lte
    column.6.styledef.case.1.comparison.operatortype=date
    column.6.styledef.case.1.comparison.righttext=$$TODAY
    column.6.styledef.case.1.comparison.trueproperty.0.name=textcolor
    column.6.styledef.case.1.comparison.trueproperty.0.value=000000
    column.6.styledef.case.1.comparison.trueproperty.1.name=bgcolor
    column.6.styledef.case.1.comparison.trueproperty.1.value=eac6c9
    column.6.styledef.case.1.comparison.truetext=
    column.6.textmode=true
    column.6.usewidths=true
    column.6.valuefield=date
    column.6.valueformat=
    column.6.width=65
    column.7.displayname=Planned Completion Date
    column.7.styledef.case.0.comparison.icon=false
    column.7.styledef.case.0.comparison.leftmethod=plannedCompletionDate
    column.7.styledef.case.0.comparison.lefttext=plannedCompletionDate
    column.7.styledef.case.0.comparison.operator=lt
    column.7.styledef.case.0.comparison.operatortype=date
    column.7.styledef.case.0.comparison.righttext=$$TODAY
    column.7.styledef.case.0.comparison.trueproperty.0.name=textcolor
    column.7.styledef.case.0.comparison.trueproperty.0.value=d30519
    column.7.styledef.case.0.comparison.trueproperty.1.name=bgcolor
    column.7.styledef.case.0.comparison.trueproperty.1.value=eac6c9
    column.7.styledef.case.0.comparison.truetext=
    column.7.styledef.case.1.comparison.icon=false
    column.7.styledef.case.1.comparison.leftmethod=opTask:plannedCompletionDate
    column.7.styledef.case.1.comparison.lefttext=opTask:plannedCompletionDate
    column.7.styledef.case.1.comparison.operator=lt
    column.7.styledef.case.1.comparison.operatortype=date
    column.7.styledef.case.1.comparison.righttext=$$TODAY
    column.7.styledef.case.1.comparison.trueproperty.0.name=textcolor
    column.7.styledef.case.1.comparison.trueproperty.0.value=d30519
    column.7.styledef.case.1.comparison.trueproperty.1.name=bgcolor
    column.7.styledef.case.1.comparison.trueproperty.1.value=eac6c9
    column.7.styledef.case.1.comparison.truetext=
    column.7.textmode=true
    column.7.usewidths=true
    column.7.valueexpression=IF(ISBLANK({task}.{name}),{opTask}.{plannedCompletionDate},{task}.{plannedCompletionDate})
    column.7.valueformat=HTML
    column.7.width=65






    If this helped you, please mark correct to help others : )
      RhondaGayleTX
      RhondaGayleTXAuthor
      Level 5
      April 24, 2023

      I am just now getting back to this and seeing your reply. Thank you so much for sharing! 

        Terms & ConditionsAccessibility statement

        Loading footer...