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

[MarkSa18]

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

[_Manish_Singh · Accepted solution]

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]

Advanced options rules:

[MarkSa18]

That works awesomely @_Manish_Singh !

Thank you for your help.

Best,

Mark

[MarkSa18]

@_Manish_Singh  sorry one more question...you have a width=100 in last line...I read documentation on width= and it does not appear to make sense...for some reason it does not permanently fix column width. Any suggestions on on locking column width?

[_Manish_Singh]

True, setting the width does not lock the column. It initially sets the column to the specified width, but once you adjust it, it does not revert to the default.

[MarkSa18]

thank you. WF is lacking in this area but I will make it work.

Appreciate you replying.

M-

[MarkSa18]

I have an anomaly...WF is not indicating 100% is complete. I think I need to change code to look at Percent Complete = 100% then complete. Any suggestions?

[_Manish_Singh]

There might be an approval process set for that task, which is why it shows as 100% complete but might still be in Complete - Pending Approval (CPL:A). Could you check this? Alternatively, as you mentioned, you can replace the status = CPL condition with percent complete = 100. I think using percent complete is better.

[MarkSa18]

again, thank you @_Manish_Singh  . and no there is no approval process But I will look to change code to the percent field.

best

mark

[Lyndsy-Denk]

Are there any open issues attached to that task? That's something I've hit before. As a result, I created this idea, if you care to upvote: Disallow 100% Percent Complete if there are open i... - Adobe Experience League Community - 748142.

[MarkSa18]

thank you @Lyndsy-Denk