Help with check boxes

Ann Alexandrowicz

Hello,

 

I am trying to figure out the formula to get a check box to auto check when two other boxes are checked. 

In the image attached, I'd like to link the check Boxes in line with Person 1 and Person 2 to the check box in line with President Elect. 

How do I do that without linking all the other lines?

 

Thanks

Mitch.Shaffer

Use this formula:

=IF(AND(Checkbox3, Checkbox4) = 1, 1)

Place the formula on the President Elect row and update "Checkbox3" and "Checkbox4" to the corresponding cells on the Person 1 and Person 2 rows.

Ann Alexandrowicz

So I just copied that formula into the box and it replied with #UNPARSEABLE

 

Any Suggestions?

Mitch.Shaffer

Did you replace "Checkbox3" and "Checkbox4" with the cells on the Person 1 and Person 2 row? Checkbox is just a placeholder name that I used because I don't know what your columns are called.

Ann Alexandrowicz

Great got it. Didn't realize I had to change the names. 

 

Thank you!