Assignment report - adding conditional formatting to shared columns

[RhondaGTriggs]

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! 

[Madalyn_Destafney · Accepted solution]

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

[RhondaGTriggs]

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