Highlighting column value when evaluating 2 conditions
Hi WF Community!
I’m looking to add red highlighting to values in a project’s task list, under the Planned Completion Date column, when the date is less than $$NOW and the task’s Status is not equal to “Complete”.
I was working with leftmethod in text mode on the Planned Completion Date column, but still not getting the result I need. Here’s my text mode:
displayname=Planned Completion Date
linkedname=direct
namekey=plannedCompletionDate
querysort=plannedCompletionDate
textmode=true
valuefield=plannedCompletionDate
valueformat=atDate
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=AND(({plannedCompletionDate}<$$NOW),({status}!=”CPL”))
styledef.case.0.comparison.lefttext=true
styledef.case.0.comparison.operator=equal
styledef.case.0.comparison.operatortype=string
styledef.case.0.comparison.trueproperty.0.name=bgcolor
styledef.case.0.comparison.trueproperty.0.value=eac6c9
styledef.case.0.comparison.truetext=
Anyone know where I might be going astray?
Thanks!
Nick