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.