Changing a formula numeric field's return color.

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress

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?
Photo of Matt Galosky

Matt Galosky

  • 70 Points

Posted 8 months ago

  • 0
  • 1
Photo of Jason

Jason

  • 1,072 Points 1k badge 2x thumb
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>"