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?
Answers
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 436 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…
- Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
- I have a sheet that compiles all the responses from a form. The sheet has multiple start and end date columns, but only one start and one end date cell is NOT blank depending on the activity selected …