nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

COUNTIF example formulas using check box columns

americansurveymanagement35236

Would anyone have a example of a formula to count checked boxes in a column divided by the number of unchecked boxes. Any help will be greatly appreciated. Thanks.

Find more posts tagged with

Formulas

Comments

Mike Wilday

This should do the trick. Checkboxes use the actual value of 1 for checked and 0 for unchecked. You can divide the two countifs with simple math like seen below.

=Countif([column name]:[Column Name], 1) / Countif([column name]:[Column name], 0)

So if your column name is Completed Task then it would look like this:

=Countif([Completed Task]:[Completed Task], 1) / Countif([Complete Task]:[Complete Task], 0)

americansurveymanagement35236

Thank you so much, that works perfect. Now I need to divide by the total number checked by the total number of boxes containg both checked and not checked. I'm so close but no cigar at this point. Any suggestions?

ricki

wouldn't it just be

=Countif([column name]:[Column Name], 1) / (Countif([column name]:[Column name], 0) + Countif([column name]:[Column name], 1))?

Also, the denominator is basically all so you could do a count rather than a countif ... but I think this formula is what you were describing

Mike Wilday

The formula dividing the total number into the number of checked is...

=countif([column name]:[column name], 1) / count([column name]:[column name])

The count function counts all unblank cells in the range.

ricki

Sign in to join the conversation!

Quick Links

Trending discussions

Filtering Graphs in Dashboards
I've created a dashboard with multiple graphs using data from the same report. I have added the report to the dashboard as well and set up the filter for use in the dashboard. Is this filter transferable to the graphs as well, given i can filter the report in the dashboard?
Multiple contact list cross linked with a single choice list
Dear Community, Can you please advise? I have a sheet where among other columns I have a column listing contacts "Champions" (multiple per cell) the other columns are for example: Countries (a list of 72) The list of Projects (approx 15) - I can add to that sheet, or I can create in a Helper Sheet. I haven't done that yet…
Can an if statement be used with index collect? Looking for value on two different sheets.
Looking for assistance again, I want to bring in the % complete from the Production sheet to the Schedule sheet, but once the % complete is 100 the data is moved to another sheet, so I would like to reference to check 1 sheet for percent complete and if it is not there check the second sheet. Schedule sheet: Pick Up Date…