Counting The Values of the cells when the colors are changed

Lawson09

Hey Community,

I'm building out a quiz to track accuracy of the results. I've set a conditional format to change the cell to "Green" when correct and "Red" when incorrect. I want to count the number of correct answers by the green cell counts but having issues with the formula, could someone assist?

Bonus: I would like to track the number correct and percentage(ex: 4/5, 80%).

Itai Perez

Hey @Lawson09 ,

Counting colored cells is not yet an option on Smartsheet.

What you can count are Symbol columns. maybe consider using them in some form to count your answers.

If this sheet is just for answers then you can change the type of the columns but dont restrict to symbol values only then you can have the letter of the question in the same column.