Expand my Community achievements bar.

SOLVED

Adding a column rule based off another column

Avatar

Level 4

In a report, I have a column for planned completion date and another column for a custom field "commit date."  I'm looking to highlight the commit date Red when it is past the planned completion date.  Any ideas?  Thanks in advance!

1 Accepted Solution

Avatar

Correct answer by
Level 7

Hi Justin - 

 

You can accomplish this by comparing the two fields using text mode code.  The easiest way to explain it is to add the fields to the report, then use the Advanced Options to create the condition, i.e., Red when 'greater than' plannedCompletionDate...Of course, you won't be able to pull the field name "plannedCompletionDate" into the advanced options field.  So... Save it, then switch to textmode.  

 

There are two things to notice... leftmethod and lefttext lines... You'll notice you only have the rightmethod line item so you need to add the rightext line item and for each replace with =plannedCompletionDate at the end like this...

 

styledef.case.1.comparison.rightmethod=plannedCompletionDate

styledef.case.1.comparison.righttext=plannedCompletionDate

 

Here's another article on the community that may help also. 

 

Hope this helps,

Teale

 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 7

Hi Justin - 

 

You can accomplish this by comparing the two fields using text mode code.  The easiest way to explain it is to add the fields to the report, then use the Advanced Options to create the condition, i.e., Red when 'greater than' plannedCompletionDate...Of course, you won't be able to pull the field name "plannedCompletionDate" into the advanced options field.  So... Save it, then switch to textmode.  

 

There are two things to notice... leftmethod and lefttext lines... You'll notice you only have the rightmethod line item so you need to add the rightext line item and for each replace with =plannedCompletionDate at the end like this...

 

styledef.case.1.comparison.rightmethod=plannedCompletionDate

styledef.case.1.comparison.righttext=plannedCompletionDate

 

Here's another article on the community that may help also. 

 

Hope this helps,

Teale