How to connect statements with conditions?
I am new in the business and i'm trying to connect some statements on my sheet, so I'll apreciate if anyone can help me with this :)
=IF([PROGRESS]2 = 1, "Green" (Status)
IF today is greater than one day of the [due date]1 , "Red"
IF [STATUS]1 IS GREEN should be green even if due date is greater than "today"
Meanwhile [STATUS] should maintain "Gray"
I hope I have made myself understood
Help Article Resources
Check out the Formula Handbook template!