Forum Discussion

AndrewWilber's avatar
AndrewWilber
Qrew Trainee
5 years ago

Multiple If Statements in conditional formatting

Hello! I am doing a conditional formatting field which I am calling "Visual status".  I am using this field to alert me to key issues with records in my system visually. I have developed the fol...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Can you say in words what do you want the logic to be for your formula. If you can see it we can help you with the formula.  You were kind of vague about the date getting close.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • AndrewWilber's avatar
    AndrewWilber
    Qrew Trainee
    5 years ago
    Thanks for asking for clarification - this is what I was thinking.  

    If BOM Release Date is before Required BOM release date --> Green
    IF BOM Release date is after required BOM release date --> Red
    IF BOM release date is empty and Required BOM release date < Today () --> Red
    IF BOM release date is empty and Today()-Days(10) < [BOM Yellow Date] ,--> yellow




    ------------------------------
    Andrew Andrew
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      If(
      [BOM Release Date] <   [Required BOM release date], $green,
      [BOM Release date]  >  [required BOM release date], $red,
      Isnull([BOM release date]) and [Required BOM release date] < Today (), $red,
      Isnull([BOM release date]) and Today()-Days(10) < [BOM Yellow Date] ,$yellow)

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------