Constraining integers in a group

Hi there, I need constraining integer responses within a group. For example, I am asking what people do with scales and have provided different options with fields to collect values (proportions for each category), whose sum must be 50. I want to ensure that surveyors do not mistakenly enter more or less than 50. I can’t upload a file as a new user, so I am sharing a Google Drive link of my form. thank you.

palatability - Copy.xlsx (18.0 KB)

Welcom @cemogor,
Often the search function of this forum (and Help Center articles) can provide solutions, e.g.


@cemogor, this post discussed previously should help you solve your issue:

This post, too should be helpful:

1 Like