Highlight task in report

[MichelleBo1]

I have a report where i need to call attention to "late" completed tasks but can't quite seem to get it right. I want to highlight the row when the Last Update Date is later than the Plan Start. See the image.

[kynabaker16]

Hi Michelle,

I know that in @Linnie Ciepielowski‚ 's Leap session she shared some great text mode to display the "Early, Late or On Time Tasks" in a report - maybe she has some great tips for you as they relate to this report ‚Äîor you can find what you need in her Leap session.

Just an idea!

Thanks,

Kyna

[LinnieCi · Accepted solution]

Hi Michelle and Kyna,

The code in my presentation is a little different (it flags tasks as "late" while taking the handoff date into account). But, here is code that should solve Michelle's issue. You can paste it into one of the columns you are comparing. I created most of this using the conditional formatting tools in the report builder, and made a few tweaks in text mode:

linkedname=direct

namekey=lastUpdateDate

querysort=lastUpdateDate

row.0.styledef.applyallcases=true

row.0.styledef.case.0.comparison.icon=false

row.0.styledef.case.0.comparison.isrowcase=true

row.0.styledef.case.0.comparison.leftmethod=lastUpdateDate

row.0.styledef.case.0.comparison.lefttext=lastUpdateDate

row.0.styledef.case.0.comparison.operator=lt

row.0.styledef.case.0.comparison.operatortype=date

row.0.styledef.case.0.comparison.rightmethod=plannedStartDate

row.0.styledef.case.0.comparison.righttext=plannedStartDate

row.0.styledef.case.0.comparison.trueproperty.0.name=textcolor

row.0.styledef.case.0.comparison.trueproperty.0.value=000000

row.0.styledef.case.0.comparison.trueproperty.1.name=bgcolor

row.0.styledef.case.0.comparison.trueproperty.1.value=eac6c9

row.0.styledef.case.0.comparison.truetext=

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.isrowcase=true

styledef.case.0.comparison.leftmethod=lastUpdateDate

styledef.case.0.comparison.lefttext=lastUpdateDate

styledef.case.0.comparison.operator=lt

styledef.case.0.comparison.operatortype=date

styledef.case.0.comparison.rightmethod=plannedStartDate

styledef.case.0.comparison.righttext=plannedStartDate

styledef.case.0.comparison.trueproperty.0.name=textcolor

styledef.case.0.comparison.trueproperty.0.value=000000

styledef.case.0.comparison.trueproperty.1.name=bgcolor

styledef.case.0.comparison.trueproperty.1.value=eac6c9

styledef.case.0.comparison.truetext=

textmode=true

valuefield=lastUpdateDate

valueformat=atDate

This article is a great resource for conditional formatting and text mode: https://one.workfront.com/s/article/Comparing-Fields-in-Conditional-Formatting-1413809645

Hope that helps!

[MichelleBo1]

I pasted this code in the update column but it didn't highlight anything. I changed the lt to gt and got what i needed. Thanks so much!

[LinnieCi]

Awesome! Glad that worked out for you.

[Kundanism]

Hei Linnie

I also tried the above works great. Also I tried to modify the above text code to know the last update done by with user id, please check;

linkedname=direct

namekey=lastUpdatedBy

querysort=lastUpdatedBy

row.0.styledef.applyallcases=true

row.0.styledef.case.0.comparison.icon=false

row.0.styledef.case.0.comparison.isrowcase=true

row.0.styledef.case.0.comparison.leftmethod=lastUpdatedBy

row.0.styledef.case.0.comparison.lefttext=lastUpdatedBy

row.0.styledef.case.0.comparison.operator=lt

row.0.styledef.case.0.comparison.operatortype=name

row.0.styledef.case.0.comparison.rightmethod=plannedStartDate

row.0.styledef.case.0.comparison.righttext=plannedStartDate

row.0.styledef.case.0.comparison.trueproperty.0.name=textcolor

row.0.styledef.case.0.comparison.trueproperty.0.value=000000

row.0.styledef.case.0.comparison.trueproperty.1.name=bgcolor

row.0.styledef.case.0.comparison.trueproperty.1.value=eac6c9

row.0.styledef.case.0.comparison.truetext=

styledef.case.0.comparison.icon=false

styledef.case.0.comparison.isrowcase=true

styledef.case.0.comparison.leftmethod=lastUpdatedBy

styledef.case.0.comparison.lefttext=lastUpdatedBy

styledef.case.0.comparison.operator=lt

styledef.case.0.comparison.operatortype=name

styledef.case.0.comparison.rightmethod=plannedStartDate

styledef.case.0.comparison.righttext=plannedStartDate

styledef.case.0.comparison.trueproperty.0.name=textcolor

styledef.case.0.comparison.trueproperty.0.value=000000

styledef.case.0.comparison.trueproperty.1.name=bgcolor

styledef.case.0.comparison.trueproperty.1.value=eac6c9

styledef.case.0.comparison.truetext=

textmode=true

valuefield=lastUpdatedBy

valueformat=name

Best regards,

Kundan.

[LinnieCi]

Hi Kundan, you may have better luck by comparing the plannedStartDate field to the lastNote:entryDate field (if you're looking for when the last note text was entered) or the lastUpdateDate field, as opposed to lastUpdatedBy.

[kynabaker16]

Ah! Well, at least you had something that could help! Thank you so much for sharing, Linnie!