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 in Archived 2016 Posts

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)


  • Greg Gates
    Greg Gates ✭✭✭✭✭

    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.