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:
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!