RYGB and Check Box

Leslie Lupo

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

Andrée Starå

Hi @Leslie Lupo

Try something like this.

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

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!