Counting Checked Boxes in one column

Hello,

I am trying to count the number of boxes that are checked in the "Missed Information" column and showcase the total in the bottom right corner of the Sheet. I have tried many different formulas:

=COUNTIFS([Missed Information:Missed Information], 1)

=COUNTIFS([Missed Information : Missed Information], 1)

=COUNTIF([Missed Information:Missed Information], 1)

=COUNTIF([Missed Information : Missed Information], 1)

I also tried entering these formulas in the Sheet Summary as well.

All of these come back with the #UNPARSEABLE error.

I also used =COUNTIFS & =COUNTIF and referenced another sheet, which was the same sheet that I was already on, and selected the entire "Missed Information" column and it keeps giving me the error below (We're having trouble reaching Smartsheet right now). Any tips on what I am doing wrong?

Find more posts tagged with

Formulas

functionality

Sheet Summary

Workflows in Smartsheet

Countif

Accepted answers

All comments

Mark Rojas

@becca moon

Try,

=COUNTIFS([Missed Information]:[Missed Information], @cell = 1)

As for the contacting Smartsheet, I get that all the time and just reload the page.

~MR

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.