Hello!
I would like to create a formula that makes a status column be either red, yellow, or green (using the symbols) and the rules read like this:
IF the due date is in the past AND the paid column is no, then show red in the status column
IF the due date is within the next 5 days, and the paid column is no, then show yellow in the status column
IF the due date is greater than 5 days out, and the paid column is no, then show green in the status column
If the paid column shows yes, then show gray in the status column
Thank you!!
