Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to Countif only the un-checked boxes in a column (leaving out blank boxes)
I understand how to countif the checkboxes in a column with the COUNTIF=([range]:[c],1) such as shown in this community post: https://community.smartsheet.com/discussion/counting-checked-boxes But I want to be able to count the boxes that are un-checked. I used CountIF=([range]:[c], 0) but it gave me the other blank boxes in the column that have no checkbox or data entered into it. If you have any idea of how to do this, I would really appreciate it.