Easy way to count unchecked boxes in a column

BarneeL
BarneeL ✭✭
edited 12/09/19 in Formulas and Functions

Hi there,

 

I'm trying to create a reference that counts the number of unchecked boxes in a column from one of my form-filled Smartsheets. I'm trying to use the formula "=COUNTIF([column2]:[column2],=false)", where "[column2]" is my checkbox column.

 

The problem I'm having is that using this formula counts all pre-generated empty rows in addition to the rows entered by the form. As a result, the formula returns a much higher value than intended.

 

Is there a way, without touching the form-filled Smartsheet, that I can make this calculation on a seperate sheet. There are no *required fields in the form, so using a column to count the total entries and subtracting 'true' values also would not work.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!