Forum Discussion

ToddMolino's avatar
ToddMolino
Qrew Cadet
7 years ago

Help with formula to capture 2018 results as well as 2019

I have this formula below that is capturing data just fine for current month and next month numbers, however 2018 numbers are not getting captured because this formula doesn't account for previous yea...
Formulas and functions
ToddMolino's avatar
ToddMolino
Qrew Cadet
7 years ago


If(
(Upper([Line]) = "LIFE") and (Year([Issue Date]) = Year(Today())) and (Month(Today()) - Month([Issue Date]) = 1) and ($Red), "Red",
(Upper([Line]) = "LIFE") and (Year([Issue Date]) = Year(Today())) and (Month(Today()) - Month([Issue Date]) = 1) and ($Yellow), "Yellow",
(Upper([Line]) = "LIFE") and (Year([Issue Date]) = Year(Today())) and (Month(Today()) - Month([Issue Date]) = 1) and ($Green), "Green", ""
)