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

jurgen93

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.

Itai

Hey @jurgen93

I think the formula you are looking for is this one :=IF(Done@row = "true", "Green", "Red")

It worked for me but let me know if I missed anything.

Itai

Hey @jurgen93

I think the formula you are looking for is this one :=IF(Done@row = "true", "Green", "Red")

It worked for me but let me know if I missed anything.

jurgen93

Yes that worked. Thank you.