Let's create a simple form for slash the sugar challenge. The purpose of this form is to track the daily activity and assign positive or negative points for each of the activity. We will use a checkboxes question with different activities as answer choices that users can select. Please follow the instructions below to assign points and calculate the score.
The form is used to track the daily activity and assign positive or negative points for each of the activity. Positive points indicate that users are successful in reducing the sugar intake. You can assign points to the answer choices in checkboxes question using SCORE function.Glass of water = 1Fresh fruits & veggies = 2Nits for snacks = 2Daily exercise = 10Soda, cocktails or drinks = -3Cookies, cakes or sweets = -5Fried food / Fast food = -6Refined grains = -1SCORE(entry#id, 1, 2, 2, 10, -3, -5, -6, -1)Note: Type @ and select the required checkboxes question from the list to add its entry #id in the above formula.
Click Submit to finish.
To use this feature, you need our Gsuite addon.
Install this addon to customize Google Forms.
Try It Free