Checkbox question

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?

Find more posts tagged with

Formulas

Government

Solution Center

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
How to Create Time Duration
I have a report where I need a formula to figure out time duration. For example, employee starts at 8:00 am and ends at 9:00 am, I need the next column to tell me 1.00 to indicate he worked 1 hour. I will be using military time throughout this sheet.