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

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

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])

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

Are you attempting to place the formula in a different sheet from the source? You will need to setup a crosssheet 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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!