Counting The Values of the cells when the colors are changed


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
    Itai ✭✭✭✭✭✭

    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.

    Itai Perez

    Reporting and Project Manager

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!