Forum Discussion

JenniferMeyer's avatar
JenniferMeyer
Qrew Member
5 years ago

Coding Help for a range of dates

Hello,
I am really struggling trying to figure out how to create a formula. I have done so much research on and it is already an area I struggle in.

I am trying to create a formula that will highlight the rows in a report a color depending on how overdue they are.

e.g. less than 30 days is no background color
30-59 days overdue would be yellow
60-89 days overdue would be green
90 days and over would be red.

Can you please help me with this?

Thank you!!



------------------------------
Jennifer Doescher
------------------------------
Formulas and functions
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago

    What is your current formula?



    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
  • GiuseppeMacri's avatar
    GiuseppeMacri
    Qrew Captain
    5 years ago

    Your color code formula should look something like this:

    If([Days Past Due]<30,null,

     If([Day Past Due]>=30 or [Day Past Due]<60, "Yellow",

     If([Day Past Due]>=60 or [Day Past Due]<90, "Green","Red")))

     



    ------------------------------
    GMacri
    ------------------------------