Skip to main content
Question

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

    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>
    Terms & ConditionsAccessibility statement