RYGB and Check Box


Hello everyone,

I am a new Smartsheet user and having problems with a function. When the "Blue" ball is selected in the Health column, I would to automatically have the check box in the Complete column checked. Embarrassed to ask such a simple question.

=IF(AND(Health@row="Blue",) (Complete@row=1,1))

Greatly appreciate the help!

Leslie Lupo


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!