Hello, I'd appreciate if someone can check my work on this health formula. It's successful when tested separately and combined, though the only one proving to cause an issue is when I add in the final line (which works separately) . Thanks in advance!
Logic:
Add a red circle to this cell if due date is in the past and the status column of this row is "not started", "in progress" or "waiting for review". Add a yellow circle to this cell if [Due Date] is 2 or less days in the future and the Status column of this row is "not started", "in progress" or "waiting for review". Add a green circle to this cell if [Due Date] is in the future with more than 2 [Days Remaining] and the [Status] column of this row is "in progress" or "waiting for review". Add a blue circle to this cell if the % Complete is 100%. Add a empty to this cell if [Status] is "Not Started" and the [Due Date] cell is blank.
=IF(AND([Due Date]@row < TODAY(), OR(Status@row = "not started", Status@row = "in progress", Status@row = "waiting for review")), "Red", IF(AND([Due Date]@row - TODAY() <= 2, OR(Status@row = "not started", Status@row = "in progress", Status@row = "waiting for review")), "Yellow", IF(AND([Due Date]@row > TODAY(), [Days Remaining]@row > 2, OR(Status@row = "in progress", Status@row = "waiting for review")), "Green", IF([% Complete]@row = 1, "Blue", IF(AND([Status]@row = "Not Started", ISBLANK([Due Date]@row)), "empty", [Status]@row)))))
