I want to calculate a percentage of 2 scores and I do not know the formula. At the bottom of my second page (I know it doesn't make sense there but it makes reading the report easier) I have my calculated total score and a possible points score. I want to know the formula to add to the answer to the "Percentage" field for it to be Score / Possible POints (SCORE) x 100%
Hope this makes sense and thank you!
Hi Amy, the responses including the calculated scores will be recorded in Google Forms and the linked Google Sheets. You can add a field for email and use the iFS function to set the value based on the answer selected for the Name dropdown field. For example.
IFS(Name == "John Doe", "john.doe@gmail.com", Name == "Jane Doe", "jane.doe@gmail.com")
Note: You must type @ and select the name field from the list when adding the formula in the Calculate option.
Fri Jan 12 2024
| 3 Replies
