Forum Discussion
MarkShnier__You
4 years agoQrew Legend
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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- AndrewWilber4 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__You4 years agoQrew LegendIf(
[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
------------------------------