Counting Checked Boxes in one column

becca moon

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?

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