I built a mulitple choice quiz and was successful in assigning a numeric value to the right answer and created a percentage formula. I wanted to know if there is a way to duplicate a formula (example: Percentage) within a column and/or row.
We expect a large amount of responses and don't want to rewrite the formula for each.
Any suggestions or thoughts? I am hoping I don't need to export to excel in order to complete this task.
You can add a column to the response table and enter the formula in a table cell for that column. The formula will be automatically applied in that column for every row, so you would not need to re-enter it for every response.
All the best,
Thank you, that answered my question!!