Color coding formula Help

  • 0
  • 1
  • Question
  • Updated 4 weeks ago
  • Answered
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.
Photo of Chris Baker

Chris Baker

  • 210 Points 100 badge 2x thumb

Posted 4 weeks ago

  • 0
  • 1
Photo of wwdmr

wwdmr

  • 236 Points 100 badge 2x thumb
if(isnull([Design Start Date]),"Blue","Other color")
Photo of wwdmr

wwdmr

  • 236 Points 100 badge 2x thumb
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.
Photo of Chris Baker

Chris Baker

  • 210 Points 100 badge 2x thumb
Perfect! Thank you!