I want the color to change to green if checkbox is checked and stay Red if it is not.

Options

I have this formula but it is not working for me.

=IF(Done@row = 1, Status@row = "Green", Status@row = "Red")

I have 2 columns, one is a checkbox column, and one is a symbol column with Green, Yellow and Red options. I want the color to change to green if checkbox is checked and stay Red if it is not.

Can someone pls help me with this.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!