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
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
------------------------------