Google Forms – Add Field to Show Sum of Multiple Number Fields

google sheetsgoogle-forms

Say for instance I want the user to input into 4 fields the meters they will dig up in different areas. On the form itself I would like to have a number at the bottom displaying the sum of 3 of said fields.

Is this possible? If it is, how do I go about getting it done?

Best Answer

Google Forms doesn't include calculated fields. One alternative is to create a web app by using Google Apps Scripts.

Related Solutions

Google-sheets – How to put the timestamp in the “check in” or “check out” column based on the user’s response in the Google form

You can do this using the copyDown add-on by filling in the right formula in line 2. You can find the copyDown add-on here: https://chrome.google.com/webstore/detail/copydown/lipbbdpmkcbplmfnbholpabinnnkbbda

Google-sheets – How to get sum of largest numbers in each individual row in Google Sheets

=SUM(MAX(A1,B1)+MAX(A2,B2)+MAX(A3,B3))

This works only for 3 rows.

A general solution would be following,

In a new column (say C) put this formula

=MAX(A1,B1)

Then apply this formula on some other cell.

=SUM(C:C)

Best Answer

Related Solutions

Google-sheets – How to put the timestamp in the “check in” or “check out” column based on the user’s response in the Google form

Google-sheets – How to get sum of largest numbers in each individual row in Google Sheets

Related Topic