The Oxford Happiness Questionnaire can be used to measure the current level of happiness. This happiness questionnaire consists of 29 statements. The items are a combination of positively and negatively phrased statements and pertain to different areas of well-being. This ensures that the respondent takes time to carefully read each item before answering. The survey asks you to evaluate each statement and rate it according to how much you disagree or agree with the statement. It uses a 6-point Likert scale with 6 being the highest as “strongly agree”. For the purpose of this article, we will focus on how to interpret the results and show a verbal assessment based on the score. To learn how to calculate the score, refer to this help article Interpreting the score, by Stephen Wright
Please follow the instructions below to display the verbal assessment based on the calculated score.
IFS function evaluates multiple conditions and returns a value that corresponds to the first true condition. The syntax for the IFS function is: IFS(condition1, value1, [condition2, value2, …]) where
For example: IFS(entry789920950 == 6, "Too happy", entry789920950 > 5, "Very happy", entry789920950 > 4, "Pretty happy", entry789920950 == 4, "Moderately happy", entry789920950 > 3, "Unhappy", entry789920950 > 2, "Somewhat unhappy", entry789920950 > 1, "Not happy")
1. Type @ and select the score question from the list to add its entry #id in the IFS formula. 2. IFS function must be written between ${ and } in the confirmation message. For example:${IFS(entry789920950 == 6, "Too happy", entry789920950 > 5, "Very happy", entry789920950 > 4, "Pretty happy", entry789920950 == 4, "Moderately happy", entry789920950 > 3, "Unhappy", entry789920950 > 2, "Somewhat unhappy", entry789920950 > 1, "Not happy")}
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to customize Google Forms.
Try It Free