Has anyone built/used a formula to capture the percentage of specific responses in a series of questions?
We're experimenting with Smartsheet Forms to be able to administer an exam. Each column would be a single-select dropdown of the multiple-choice exam question format. On the backend, we want there to be a formula capturing the percentage of correct answers.
Help Article Resources
Check out the Formula Handbook template!