Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoCan 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- AndrewWilber5 years agoQrew TraineeThanks 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__You5 years ago
Qrew Legend
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
------------------------------