Discussions

 View Only
  • 1.  Color coding formula Help

    Posted 02-20-2019 16:17
    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.


  • 2.  RE: Color coding formula Help

    Posted 02-20-2019 16:20
    if(isnull([Design Start Date]),"Blue","Other color")


  • 3.  RE: Color coding formula Help

    Posted 02-20-2019 16:24
    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.


  • 4.  RE: Color coding formula Help

    Posted 02-20-2019 16:25
    Perfect! Thank you!