Checkbox question

03/22/18 Edited 12/09/19

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?

Comments

  • Mike WildayMike 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)

     

  • 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 WildayMike 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 WildayMike 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)

    2018-03-22_17-02-30.gif

  • Got it to work!  thank you!  

     

  • 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 WildayMike 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
  • 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 WildayMike Wilday ✭✭✭✭✭

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

Sign In or Register to comment.