Form field controls so data entry is required to sum 100 percent?

JWood

We're sending out a survey to understand how much time employees are spending working for each of two departments.

We want employees enter time spent as a percentage to add up to 100%.

For example an employee might enter 40% for dept "a" and therefore they have to enter 60% for dept "b".

Or better yet, whatever they enter for dept "a", dept "b" automatically populates to equal a total of 100%.

Any way to do this on a form field?

Paul Newcome

There is no way to do this in a form field while entering the data, but you can use a formula in the sheet to auto-calculate after the form is submitted.