Checkbox question

tcanelli41471

Is there a way to have a checkbox automatically checked if other columns with checkboxes get checked?

I have 4 columns with checkboxes and instead of doing value columns for each one I would like to do a summary checkbox and just value one column.  If that's not possible, can you set values for more than one column?

Mike Wilday

=IF(OR([checkbox column one]24 = 1, [checkbox column two]24 =1, [checkbox column three]24=1, [checkbox column four]24 = 1), 1, 0)

This formula can be placed in your summary column. Replace the words checkbox column one, etc. with the actual header names of those columns... adjust the row number to whichever row you want and it should work great for you.  (mine are set for row 24)

 

tcanelli41471

I keep getting unparseable error.  I would love to have all my counts and totals on a completely different sheet but can't get the cross reference formulas to work either.  

Mike Wilday

The unparseable error usually means you didn't set your column headers correctly in the formula. Can you share a screenshot of your column headers so we can see what you are seeing? 

https://help.smartsheet.com/articles/2476176-formula-error-messages#unparseable

It could also be that your quotes are not accurate. Sometimes if you compose your formulas in a word-processor it adds smart-quotes to your formula which cause errors in smartsheet. Copy and paste your formula into notepad which can strip all the fancy html formatting and give you a cleaner experience.

Mike Wilday

If your column names end in numbers or have spaces be sure to use the brackets. If they don't then remove the brackets as in my example below. 

=IF(OR(one2 = 1, two2 = 1, three2 = 1, four2 = 1), 1, 0)

tcanelli41471

Got it to work!  thank you!  

 

tcanelli41471

Can I ask you another formula question?  I have to get a count for total under 17 and over 65.  Would I do this on the date column or age column?  Formulas are not my thing.

Mike Wilday

I would do it on the age column. I think I replied to that thread. https://community.smartsheet.com/discussion/what-would-formula-be

wsnow11

Got this to work, but have a follow up.  This formula clicks the checkbox even if only 1 of many other checkboxes are checked.  What formula do I use to only check the final checkbox, if all preceding boxes in the formula have been checked?

Mike Wilday

IF you require ALL of the checkboxes to be checked... changed the OR to an AND.