Skip to main content
Question

Coding Help for a range of dates

  • December 30, 2020
  • 0 replies
  • 14 views

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
------------------------------
This topic has been closed for replies.

  • Quickbase Alumni
  • December 30, 2020

What is your current formula?



------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------

  • Quickbase Alumni
  • December 30, 2020

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
------------------------------