Question on an IF statement formula

Shannon Scarbrough · 04/12/21

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!!

Paul Newcome · 04/12/21

Try something like this...

=IF(Paid@row = "Yes", "Gray", IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row <= TODAY(5), "Yellow", "Green")))

Paul Newcome · 04/12/21

Try something like this...

=IF(Paid@row = "Yes", "Gray", IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row <= TODAY(5), "Yellow", "Green")))

Shannon Scarbrough · 04/12/21

That worked great - thanks Paul!

Paul Newcome · 04/12/21

Happy to help. 👍️

Best Answer