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%).
Answers
-
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🙂
https://www.linkedin.com/in/itai-perez/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!