Check Flag with formula

I am trying to turn on a flag with a formula. I am using the below, my problem is that the flag does not turn red, when I enter the formula the flag disappears and I get a 1. When I take the flag formatting off and change it to text I get "true" and then turn the flags back on I get my red flags, but then I try it again in a new cell and I get 1's. 

 

=IF(OR([Risk Rating]@row = "Red", [Risk Rating]@row = "Yellow"), "1")

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!