Expand my Community achievements bar.

SOLVED

Highlight task in report

Avatar

Level 5

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.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 7

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!

View solution in original post

7 Replies

Avatar

Employee

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

Avatar

Correct answer by
Level 7

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!

Avatar

Level 5

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!

Avatar

Level 10

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.

Avatar

Level 7

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.

Avatar

Employee

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