Cannot calculate checkbox column

Dan Harris
Dan Harris ✭✭✭✭✭
edited 05/12/21 in Formulas and Functions

I am trying to calculate the number of checked cells in a column (named 'Done'), however I keep getting errors!

The checked ('Done') column in question is pulling from another sheet using index links so will throw up a tick in the check box and a #NO MATCH accordingly.

The calculation i am using to pull from the checked column is: =COUNTIF(Done:Done, "1"). This will throw up #NO MATCH

Is there a way to ignore the #NO MATCH so the calculation works?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!