Forum Discussion

ChrisBaker1's avatar
ChrisBaker1
Qrew Cadet
7 years ago

Color coding formula Help

I am trying to create a formula to turn records that are missing a date a certain color. Here is what I have so far:

If([Design Start Date]=(null),"blue")

Quick Base is not stating that there are any errors with the formula but it is not returning the expected results.
Formulas and functions
    • WladimirLlanos's avatar
      WladimirLlanos
      Qrew Member
      7 years ago
      Also, you can create a formula rich text and use the follow code:

      if(isnull([Design Start Date]),"<CENTER><div style=\"color:white; background-color:blue;\">"& " blue" &"</div></CENTER>","<CENTER><div style=\"color:white; background-color:green;\">"& "Other Color" &"</div></CENTER>")

      Or, simply you can use Color-Coding option in the report settings. All is up to you.