Checkbox Formula Not Working in Metrics Sheet

I am trying to make a metrics sheet that shows how many checked boxes there are in my sheet. The tutorials I found said that "true" and "false" mean whether the box is checked or not.

Why are my results showing as 0? I should have at least 20 as checked.

I used the formula COUNTIF({checkbox 1}, [Column7]@row)

This was generated by linking the main data sheet and then typing "," and then clicking the word true in column7 on my metrics sheet.

I will attach photos below:

Find more posts tagged with

Sheets

Formulas

Cell linking

Accepted answers

All comments

Carson Penticuff

Checkboxes are treated as 1 and 0. 1 = checked, 0 = unchecked

True: =COUNTIF({checkbox 1}, 1)

False: =COUNTIF({checkbox 1}, 0)

Adrian Mandile CHESS

Hi @megtro610,

Further to @Carson Penticuff's response, if you are using the 'Metrics' sheet for charting purposes, I most often have a 'Criteria' Column to use in the formula and a separate "LABEL" column (often as the Primary Column). So, in your case, you can have 1 or 0 in criteria 'Column7' and to the right of it (and contiguous with the data to be charted) the label text of "True" or "False", "Yes" or "No", or whatever other terms have more meaning.

Then in the chart widget, you can select the contiguous block of cells including the "LABEL" column (Hint: I always use UPPER CASE for Primary Columns) and the data column(s) and chart away with meaningful Series names.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.