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

  • Itai Perez
    Itai Perez ✭✭✭✭✭✭
    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

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!