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!


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

Like this. 

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


You're welcome.