I want the color to change to green if checkbox is checked and stay Red if it is not.
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
-
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 Perez
Project Manager | Transformation Department
Gong cha
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
Answers
-
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 Perez
Project Manager | Transformation Department
Gong cha
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
-
Yes that worked. Thank you.
Help Article Resources
Categories
Check out the Formula Handbook template!
