IF condition statement from multiple columns & properties

Options

Need help populating the right color in my status column, which uses Red, Yellow, Green circle symbols depending on what other columns are reporting. I assume the below could be written with a formula.

IF column B is blank, then RED. IF column B is not blank, then Yellow. IF column C is checked, then Green.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!