Forum Discussion

TonyMiller's avatar
TonyMiller
Qrew Member
2 years ago

Multiple Color-Coding Formula within a report

I'm trying to create a formula in a report to highlight certain colors based on proximity to a date. If([Escalation Date]<Today(),"red", [Escalation Date]>Today xxxxx,"Yellow")  The xxxx is what I'...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

try bthis

 Back to discussions
Expand all | Collapse all

Multiple Color-Coding Formula within a report

  • 1. 

    0 Like
    Posted 3 minutes ago
    Reply

    I'm trying to create a formula in a report to highlight certain colors based on proximity to a date.

    If([Escalation Date]<Today(),"red", [Escalation Date]>Today xxxxx,"Yellow")  The xxxx is what I'm having issues with.  I want the row in the report to highlight Yellow if Escalation Date is within 3 days of now.  Example:  If today is the 8th, and the Escalation Date is within 3 days, then highlight yellow.  This is the current formula:

    If(
    [Escalation Date]<Today(),"Red",
    [Escalation Date]<=Today()+Days(3),"Yellow")



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
TonyMiller's avatar
TonyMiller
Qrew Member
2 years ago

Perfect.  That worked.  I figured it was something simple.



------------------------------
Tony Miller
------------------------------