Date to move ahead 1 year from scheduled due date, unless RYG ball is "Not' Green
I am hoping someone could help me figure out how to create a formula to calculate the date, 1 year from a date selected if my RYG ball is "Green". This date would consistently be rolling toward the future unless an RYG ball is "Yellow" or "Red".
I am working on a maintenance sheet, which we will be getting every piece of equipment in our shop on a schedule. Every year at the same time we will be maintenancing these machines, however, I need a way to determine if the machines actually got maintenanced before the formula auto-calculates to the next year. My hope is that it will only roll forward if it's past its scheduled due date, and the RYG ball has been turned "Green", otherwise, it'll stay the same date.
Photo attached for
Thank you in advance,
Help Article Resources
Check out the Formula Handbook template!