Forum Discussion

AndrewWilber's avatar
AndrewWilber
Qrew Trainee
4 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
Qrew Champion
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
4 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
    Qrew Champion
    4 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
    ------------------------------