# How to combine if statements utilizing information in multiple columns

Hello,

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.

The easiest way to implement this would be to ignore the due date logic entirely. I added an IF at the beginning that makes it only run through the code you have if the status is not "Done"

I tested this on one of my sheets and it worked

=IF([email protected] = "Done", "Green", IF(ISBLANK([email protected]), "", IF([email protected] - TODAY() > 5, "", IF([email protected] <= TODAY(), "Red", "Yellow"))))

For you it should look like this:

=IF([email protected] = "Completed", "Green", IF(ISBLANK([Due Date]@row), "", IF([Due Date]@row - TODAY() > 5, "", IF([Due Date]@row <= TODAY(), "Red", "Yellow"))))

The easiest way to implement this would be to ignore the due date logic entirely. I added an IF at the beginning that makes it only run through the code you have if the status is not "Done"

I tested this on one of my sheets and it worked

=IF([email protected] = "Done", "Green", IF(ISBLANK([email protected]), "", IF([email protected] - TODAY() > 5, "", IF([email protected] <= TODAY(), "Red", "Yellow"))))

For you it should look like this:

=IF([email protected] = "Completed", "Green", IF(ISBLANK([Due Date]@row), "", IF([Due Date]@row - TODAY() > 5, "", IF([Due Date]@row <= TODAY(), "Red", "Yellow"))))

• That is extremely helpful and worked!! Thank you so very much!!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!