# Question on an IF statement formula

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

• Try something like this...

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

• Try something like this...

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

• That worked great - thanks Paul!

• Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!