Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Checkbox Formula Not Working in Metrics Sheet

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

  • Community Champion

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

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

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

  • ✭✭✭✭✭

    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!

Trending in Formulas and Functions