Help with changing text color to "red" if task is past due in text mode | Community
Skip to main content
M
MarkSa18
Level 2
April 23, 2025
Solved

Help with changing text color to "red" if task is past due in text mode

  • April 23, 2025
  • 1 reply
  • 945 views

I could use help with changing text color to "red" if the task past due in text mode

 

I tried the following to no avail 😞

displayname=Completion Status
linkedname=direct
namekey=completionStatus
querysort=completionStatus
valueexpression=IF(ISBLANK({actualCompletionDate}) && {plannedCompletionDate} < $$TODAY, "<span style='color:#d30519'>Overdue</span>", "On Track")
valueformat=HTML

 

 

THANK YOU!

Mark

Best answer by _Manish_Singh

Hi @marksa18 - Try this. Copy and paste the text as a new column, then switch from text mode to standard mode to see the logic under Advanced Options.

case.0.comparison.icon=false case.0.comparison.isrowcase=false case.0.comparison.leftmethod=status case.0.comparison.lefttext=status case.0.comparison.operator=in case.0.comparison.operatortype=string case.0.comparison.righttext=CPL case.0.comparison.truetext=Completed case.2.comparison.icon=false case.2.comparison.isrowcase=false case.2.comparison.leftmethod=plannedCompletionDate case.2.comparison.lefttext=plannedCompletionDate case.2.comparison.operator=lt case.2.comparison.operatortype=date case.2.comparison.righttext=$$TODAY case.2.comparison.truetext=Overdue case.3.comparison.icon=false case.3.comparison.isrowcase=false case.3.comparison.leftmethod=plannedCompletionDate case.3.comparison.lefttext=plannedCompletionDate case.3.comparison.operator=gte case.3.comparison.operatortype=date case.3.comparison.righttext=$$TODAY case.3.comparison.truetext=On Track displayname=Completion Status linkedname=direct namekey=plannedCompletionDate querysort=plannedCompletionDate styledef.case.0.comparison.icon=false styledef.case.0.comparison.isrowcase=false styledef.case.0.comparison.leftmethod=status styledef.case.0.comparison.lefttext=status styledef.case.0.comparison.operator=in styledef.case.0.comparison.operatortype=string styledef.case.0.comparison.righttext=CPL styledef.case.0.comparison.trueproperty.0.name=textcolor styledef.case.0.comparison.trueproperty.0.value=000000 styledef.case.0.comparison.truetext=Completed styledef.case.1.comparison.icon=false styledef.case.1.comparison.isrowcase=false styledef.case.1.comparison.leftmethod=plannedCompletionDate styledef.case.1.comparison.lefttext=plannedCompletionDate styledef.case.1.comparison.operator=lt styledef.case.1.comparison.operatortype=date styledef.case.1.comparison.righttext=$$TODAY styledef.case.1.comparison.trueproperty.0.name=textcolor styledef.case.1.comparison.trueproperty.0.value=d30519 styledef.case.1.comparison.truetext=Overdue styledef.case.2.comparison.icon=false styledef.case.2.comparison.isrowcase=false styledef.case.2.comparison.leftmethod=plannedCompletionDate styledef.case.2.comparison.lefttext=plannedCompletionDate styledef.case.2.comparison.operator=gte styledef.case.2.comparison.operatortype=date styledef.case.2.comparison.righttext=$$TODAY styledef.case.2.comparison.truetext=On Track valuefield=plannedCompletionDate valueformat=mediumAtDate width=100

 

1 reply

_Manish_Singh
_Manish_SinghAccepted solution
Level 9
April 24, 2025

Hi @marksa18 - Try this. Copy and paste the text as a new column, then switch from text mode to standard mode to see the logic under Advanced Options.

case.0.comparison.icon=false case.0.comparison.isrowcase=false case.0.comparison.leftmethod=status case.0.comparison.lefttext=status case.0.comparison.operator=in case.0.comparison.operatortype=string case.0.comparison.righttext=CPL case.0.comparison.truetext=Completed case.2.comparison.icon=false case.2.comparison.isrowcase=false case.2.comparison.leftmethod=plannedCompletionDate case.2.comparison.lefttext=plannedCompletionDate case.2.comparison.operator=lt case.2.comparison.operatortype=date case.2.comparison.righttext=$$TODAY case.2.comparison.truetext=Overdue case.3.comparison.icon=false case.3.comparison.isrowcase=false case.3.comparison.leftmethod=plannedCompletionDate case.3.comparison.lefttext=plannedCompletionDate case.3.comparison.operator=gte case.3.comparison.operatortype=date case.3.comparison.righttext=$$TODAY case.3.comparison.truetext=On Track displayname=Completion Status linkedname=direct namekey=plannedCompletionDate querysort=plannedCompletionDate styledef.case.0.comparison.icon=false styledef.case.0.comparison.isrowcase=false styledef.case.0.comparison.leftmethod=status styledef.case.0.comparison.lefttext=status styledef.case.0.comparison.operator=in styledef.case.0.comparison.operatortype=string styledef.case.0.comparison.righttext=CPL styledef.case.0.comparison.trueproperty.0.name=textcolor styledef.case.0.comparison.trueproperty.0.value=000000 styledef.case.0.comparison.truetext=Completed styledef.case.1.comparison.icon=false styledef.case.1.comparison.isrowcase=false styledef.case.1.comparison.leftmethod=plannedCompletionDate styledef.case.1.comparison.lefttext=plannedCompletionDate styledef.case.1.comparison.operator=lt styledef.case.1.comparison.operatortype=date styledef.case.1.comparison.righttext=$$TODAY styledef.case.1.comparison.trueproperty.0.name=textcolor styledef.case.1.comparison.trueproperty.0.value=d30519 styledef.case.1.comparison.truetext=Overdue styledef.case.2.comparison.icon=false styledef.case.2.comparison.isrowcase=false styledef.case.2.comparison.leftmethod=plannedCompletionDate styledef.case.2.comparison.lefttext=plannedCompletionDate styledef.case.2.comparison.operator=gte styledef.case.2.comparison.operatortype=date styledef.case.2.comparison.righttext=$$TODAY styledef.case.2.comparison.truetext=On Track valuefield=plannedCompletionDate valueformat=mediumAtDate width=100

 

_Manish_Singh
_Manish_Singh
Level 9
April 24, 2025

Advanced options rules:

M
MarkSa18Author
Level 2
April 24, 2025

That works awesomely @_manish_singh !

Thank you for your help.

Best,

Mark

 

Terms & ConditionsAccessibility statement

Loading footer...