Auto Flagging Yes or No answers

Z@Knight

Hey everyone!

This is my first post on smartsheet, so please bear with me. I'm trying to build a Production Report. I'd like the Red Flag to turn on whenever the "Was Production Met" column says "No". This is my current formula: =IF([Was Production Met?]1 = 0, 1). I can make it work with a checkbox, but no luck with yes or no. I know this should be easy, however, I'm racking my brain. Thank you for any help!

Paul Newcome

Change the 0 to "No" (include the quotes around the no). That should do it for you.

Mike Wilday

Like this. 

=IF([Was Production Met?]1 = "No", 1)

Z@Knight

Thanks! 

Mike Wilday

You're welcome.