Checkbox Formula Not Working in Metrics Sheet

megtro610
megtro610
edited 11/25/24 in Formulas and Functions

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:

Answers

  • Carson Penticuff
    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
    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.

    Adrian Mandile
    CHESS Consulting Australia - Smartsheet Solution Provider Gold Partner
    Collaborative | Holistic | Effective | Systems | Solutions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!