If i check this checkbox, then check another check box

Bryan Long

I am looking for a formula that says... if i check this box on this sheet then go check another box on another sheet.

What am i missing to make the 2nd box get checked when Purchased @ row 1 is checked?

=IF(Purchased@row = 1, {other sheet Range 2} = 1, 2)

Andrée Starå

Hi @Bryan Long

Is it only one checkbox?

Have you explored using cell-linking instead?

Would that work/help?

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!