COUNTIF formula for number of boxes checked is not working

I have a very simple need to generate a count of how many boxes are "marked for disposal" via counting how many cells boxes are checked in a certain column, I have attached a screenshot. The formula is not working, it has given me a count of 0 when placed in text only cell and it does not give me anything when it is in the checkbox cell even though the column is not restricted to check box use only. Help! I have tried both of the below formulas:

=SUMIF([TEMP COLUMN]6:[TEMP COLUMN]25, =1)

=COUNTIF([TEMP COLUMN]6:[TEMP COLUMN]25, =1)

Find more posts tagged with

Accepted answers

Paul Newcome

It sounds like you are trying to put this in a checkbox column? If so (and it also sounds like you are putting this in the parent rows), give this a try:

=COUNTIFS(CHILDREN(), @cell = true) + ""

That's a "plus quote quote" there at the end^^

Paul Newcome

Unfortunately the "plus quote quote" converts it into a text value output. We need this to get it to populate in the checkbox column, but that also makes it so that you can't add them up. At that point is is the same as trying to add letters together.

But… What you can do is leverage the DESCENDANTS function to count all descendant rows that are checked.

=COUNTIFS(DESCENDANTS(), @cell = true) + ""

All comments

Rasika Kulkarni

Why don't you try this formula

=CountIf([Mark for Disposal]: [Mark for Disposal], 1)

=CountIf([Mark for Disposal]: [Mark for Disposal], true)

Smartsheet treats checked checkboxes as 1 or true. I hope this will help you.

MirandaLang

https://community.smartsheet.com/discussion/comment/490588#Comment_490588

Thank you! I just tried both and the formula errored and said "BOOLEAN EXPECTED".

Paul Newcome

It sounds like you are trying to put this in a checkbox column? If so (and it also sounds like you are putting this in the parent rows), give this a try:

=COUNTIFS(CHILDREN(), @cell = true) + ""

That's a "plus quote quote" there at the end^^

Rasika Kulkarni

1.Formula must exactly match your column header

2.Column type "Mark for Disposal" is a checkbox not a text/number Right click column header→Edit column properties

3. No extra characters in header

or try this

=CountIf([Mark for Disposal]: [Mark for Disposal], 1) only if you verified checkbox column some accepts true some accepts 1

MirandaLang

https://community.smartsheet.com/discussion/comment/490593#Comment_490593

Thank you, that did the trick!! Do you know how I would be able to use a similar formula to get a sum of all the counts? I appreciate the help!

Paul Newcome

But… What you can do is leverage the DESCENDANTS function to count all descendant rows that are checked.

=COUNTIFS(DESCENDANTS(), @cell = true) + ""

MirandaLang

Ohhh, I see I see. Thank you so much for the help! That formula worked as well!

Paul Newcome

Happy to help. 👍️

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.