Check Flag with formula

pea.ccu49236

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")

Chris McKay

Hi,

Your core issue here is the "1". Numeric values do not need quotes. You should also include a FALSE value in case the condition is not TRUE.

So simply change your formula to:

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

Kind regards,

Chris McKay

pea.ccu49236

Thank you!

Chris McKay

My pleasure