Counting # of checked boxes in one column

Options
c.marie
c.marie
edited 12/09/19 in Formulas and Functions

Hi all,

I've tried a few different formulas but can't figure out how to count the # of checked boxes in a column. My column is labeled "Approved" and has 131 cells, so I tried:

 =COUNTIF(approved1:approved131, 1)

But I'm getting #BOOLEAN EXPECTED

Tags:

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    That particular error means the formula is in a specific type of column (Date, Number, Symbol) and the returned value is of a different type.

     

    You can either move the formula to a different column, or convert the result to the appropriate type.

     

    Formula results may be converted to text values by adding an empty string. For example =TODAY() + "" will allow you to enter today's date into a text column.

     

    What column type are you entering the formula into? That particular one needs to go into a text/number type column.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!