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. https://docs.google.com/spreadsheets/d/1Faoiu_5eqRaExGB5XAHEn_FG710SMUf1/edit?usp=sharing&ouid=109355821027404963770&rtpof=true&sd=true 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)