Forum Discussion

MattGalosky's avatar
MattGalosky
Qrew Member
7 years ago

Changing a formula numeric field's return color.

Hi i am very new to Quickbase.  I have a field that i created that shows the number of days since the first contact date to a potential independent contractor that we want to work for us.  I want that numeric field to return not only the number of days since the first contact with the "IC" but if the time period is over 30 days i want that number to appear red.  Can someone guide me in the right direction?
Formulas and functions

1 Reply

Sort By
  • JasonJohnson's avatar
    JasonJohnson
    Qrew Assistant Captain
    6 years ago
    In case you have not found the answer. make a Rich Text Formula field with the following but replace the [First Contact Date] with the field that you are using to track the contact date.
    "<div style='color:#ff0000'>" &ToDays(Today()-[First Contact Date])& "<div>