I need a formula that looks at 2 different columns to determine if the project is Closed or Open

Newbie here...

I have 2 columns that are formatted for the green, red, yellow, and gray dot symbols. I am only using the Green, Red, and Gray dots.

The first column is "1st Half or Full Invoice". The second column is "2nd Half Invoice"

Green = Paid; Red = Not Paid; Gray = NA

In both columns, if there are only green or grey dots, then the project is Closed.

But if there is a red dot in either column then the project is Open.

I need a formula that will show that. any ideas?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!