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.
Formula to count check boxes in row one of column
I have a questionnaire with multiple columns. Responses are either check boxes or comments. I want to summarise the total check boxes in each column. I can add a column and write a formula to total the checkboxes, but the error message "#1 or 0 expected" appears when the formula is in the same column as the check boxes. (sounds like the formula need to have an answer of true or false.) I didn't want to double my # of columns.
Any easy way to tally a column of check boxes?
Used "=COUNTIF([Being aware and informed about it?]2:[Being aware and informed about it?]35, 1)" There are now only 354 responses, but hope for several hundred more.
Should I be using a report for this?