#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# check box formula

edited 12/09/19

I am trying to get a check box to automatically check itself when a range of other check boxes are checked off, I have tried a few formulas with no luck, below is my latest formula

=IF([Sand 1]294:[Sand 1]310 = 1), 1)

• ✭✭✭✭✭

I think you can get your desired functionality using the COUNTIF function combined with an IF-statement. If you wanted to mark a box if 7 specific checkboxes are all checked, then you might write something like this:

=IF(COUNTIF([Checkbox Column 1]1:[Checkbox Column 1]7,1)=7,1,0)

Basically the formula says:

1. Count all of the boxes that are checked (equal to 1)
2. If the count of these boxes is equal to 7 (the number of boxes in my range), then check this current box, otherwise, don't

I hope that works for you!

• Works great, thanks for your help...

This discussion has been closed.