I have this calculated column formula for stop lights and I just need a little help to tweak this formula.
= IF (OR ([Date Needed]* <Today, date + 90<Today), "red", IF (OR (modified + 15<* Today, Status = "project"), "yellow", "green"))
The additional requirement is to have all statuses equal to closed = green instead of red. The red light marks them in red because the [modified date] is> 15 days. Any help is appreciated!
Also, I put the * for the complete formula to appear. I'm pretty new here …