Auto Flagging Yes or No answers
Options
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!
Comments
-
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)
-
Thanks!
-
You're welcome.
