I am trying to add total count of column highlighted with a check box and for some reason am stumped

Options

Best Answer

Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Options

    Do you mean you are trying to count how many rows have a check in that column?

    Since "checked" = 1 and "unchecked" = 0, you can just sum the column.

    =SUM([Denied due to Behavior Checked]:[Denied due to Behavior Checked])

  • Wendy Gaines
    Wendy Gaines ✭✭✭
    Answer ✓
    Options

    I am trying to add the formula from my reference sheet here but it says unparseable

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Options

    Are you attempting to place the formula in a different sheet from the source? You will need to setup a cross-sheet reference in the sheet you are placing the formula which references the relevant column in your reference sheet. This formula should then give you the result.

    =COUNTIFS({Denied due to Behavior Checked}, 1)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!