Hi Amy, You can add the formula to calculate the percentage score. Instructions below. In the Edit page, click on the gear icon next to the Percentage field > Field settings page will be displayed > click Answer > enter the below formula in the Calculate option and click Save. If the total possible points is 50, then you can add the formula Score/50 * 100 Note: - You must type @ and select the score field from the list when adding the formula in the Calculate option - You must NOT type the = symbol before the formula in the Calculate option Please try this and confirm.

Thank you! The formula works for my percentage. Should the score calculations from the formfacade form translate to the google forms/sheet responses? Also, is there any way to link an email address to a dropdown menu response to avoid having to input an email for each submission? For example, in my student name dropdown, if I choose "Amanda Aydelotte" I want the form to tie that to an email address for a submission message. Hope that makes sense!

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.