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%).

Smartshhet - Screenshot - Quiz formula .png

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.