How to combine if statements utilizing information in multiple columns
I currently have the following formula to automatically have a color coded dot assigned in a column depending on the due date.
=IF(ISBLANK([Due Date]@row), "", IF([Due Date]@row - TODAY() > 5, "", IF([Due Date]@row <= TODAY(), "Red", "Yellow")))
Can you help me add to this same formula an if statement that specifies:
If Status in the row is "Complete", mark at green. If it's not, complete, follow the rest of the rules above.