If i check this checkbox, then check another check box

Bryan Long
Bryan Long ✭✭
edited 01/21/21 in Formulas and Functions

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)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!