I can not find out from your FAQ or UI how to output which categories received the most points. I assigned points with category names to each question, but I can not see which formula I should use to determine which category is the winner.
You can use the TITLE function with the MAX function to display the name of the question with the max score.
MAX function
You can use the MAX function to find the highest value in a set of give data.
MAX(category_score_field_1, category_score_field_2, category_score_field_3)
The above formula will return the highest score of the 3 fields. For example, if the value for the category_score_field_1, category_score_field_2, category_score_field_3 fields are 2, 10, 8 respectively, then the above formula will return 10.
TITLE function
If you would like to find the field with the highest score, then you can use the TITLE and MAX function.
TITLE(MAX(category_score_field_1, category_score_field_2, category_score_field_3)
The above formula will return the name of the field with the highest score. For example, if the value for the category_score_field_1, category_score_field_2, category_score_field_3 fields are 2, 10, 8 respectively, then the above formula will return the name of category_score_field_2.
Note: You must type @ and select the fields from the list when adding the formula in the Calculate option.
Comments (1)
Apr 19
You can use the TITLE function with the MAX function to display the name of the question with the max score. MAX function You can use the MAX function to find the highest value in a set of give data. MAX(category_score_field_1, category_score_field_2, category_score_field_3) The above formula will return the highest score of the 3 fields. For example, if the value for the category_score_field_1, category_score_field_2, category_score_field_3 fields are 2, 10, 8 respectively, then the above formula will return 10. TITLE function If you would like to find the field with the highest score, then you can use the TITLE and MAX function. TITLE(MAX(category_score_field_1, category_score_field_2, category_score_field_3) The above formula will return the name of the field with the highest score. For example, if the value for the category_score_field_1, category_score_field_2, category_score_field_3 fields are 2, 10, 8 respectively, then the above formula will return the name of category_score_field_2. Note: You must type @ and select the fields from the list when adding the formula in the Calculate option.
Add your comment
Add photo