Expand my Community achievements bar.

SOLVED

Column Rule for Actual Completion Date is greater than Planned Completion Date

Avatar

Level 2

Hi, I am looking to add a column rule for a report to highlight in red if the actual completion date exceeds the planned completion date. I tried to find other conversations on here but couldn't find an exact solution.

 Screenshot 2023-12-18 at 5.40.31 PM.png

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@kayleeric7  Here is the code you can use to get the desired highlight if actual completion date is greater than the planned completion date.

 

You'll want to navigate to the column you want to highlight, switch to text mode and paste this below the data that populates.

 

styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=actualCompletionDate
styledef.case.0.comparison.lefttext=actualCompletionDate
styledef.case.0.comparison.operator=gt
styledef.case.0.comparison.operatortype=date
styledef.case.0.comparison.rightmethod=plannedCompletionDate
styledef.case.0.comparison.righttext=plannedCompletionDate
styledef.case.0.comparison.trueproperty.0.name=bgcolor
styledef.case.0.comparison.trueproperty.0.value=eac6c9
styledef.case.0.comparison.truetext=

 

 

Also, the link Skye posted is great for learning how to do this.




View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

@kayleeric7  Here is the code you can use to get the desired highlight if actual completion date is greater than the planned completion date.

 

You'll want to navigate to the column you want to highlight, switch to text mode and paste this below the data that populates.

 

styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=actualCompletionDate
styledef.case.0.comparison.lefttext=actualCompletionDate
styledef.case.0.comparison.operator=gt
styledef.case.0.comparison.operatortype=date
styledef.case.0.comparison.rightmethod=plannedCompletionDate
styledef.case.0.comparison.righttext=plannedCompletionDate
styledef.case.0.comparison.trueproperty.0.name=bgcolor
styledef.case.0.comparison.trueproperty.0.value=eac6c9
styledef.case.0.comparison.truetext=

 

 

Also, the link Skye posted is great for learning how to do this.