Chapter 4 · Formulas

Calculated fields

Write a formula in the Calculate option of a Formfacade question to work out an answer from other answers, such as a total, a price, or a label chosen with IFS.

Quick Answer

How to add a calculated field in Google Form?

Google Forms does not support calculations in the form. In Formfacade, click on the ⚙️ icon of a question, select the Answer tab and write a formula in the Calculate option, such as Price * Quantity or TODAY(). Type @ to add another question to the formula. The value is shown in real time to the person filling in the form and is saved with the response.

Every formula goes in the Calculate option of a question. The value shows while people fill in the form, and it's saved in your Google Form with the rest of the response, so it reaches Google Sheets too. Dates and scores have their own functions: see Date functions and Score functions.

Where do I write a formula?

Open your form on the Edit tab

Import your Google Form. Your form opens on the Preview tab. Click the Edit tab.

Add the question that shows the result

Click on the + icon (Add field) in the toolbar on the right and enter the question, such as "Total amount". The examples on this page use a Short answer for a number and a Date question for a date.

Open the Answer tab

Click on the ⚙️ icon at the bottom right of the question and select the Answer tab.

Write the formula

Write the formula in the Calculate option. When you type @, you see the list of all the fields in the form. Select one to add it to the formula. Click Save.

  • You see the display name of a field in the formula, but internally it uses the entry id for the calculations.
  • A question with a formula turns read only by itself, so people can't change the value.
  • To keep a calculated value off the form, change the question's Appearance to hidden on the Answer tab.

Names in the formulas on this page

A name such as Price, date_of_birth or start_date stands for a question you add to the formula with @.

Calculated fields

A calculated field works out its value from other fields. It can do arithmetic on number fields and work with text and dates.

How to add a simple calculated field to a Google Form?

Calculations can only be performed on number fields. For each question you calculate with, click on the ⚙️ icon, select the Answer tab, click Configure under Validation, select Number and select Is number. Then write the expression in the Calculate option of the result question:

Price * Quantity

Use +, -, *, / and parentheses, as in the examples on this page. Full article

Conditional logic with IFS

The IFS function evaluates multiple conditions and returns the value for the first true condition.

IFS(condition1, value1, [condition2, value2, …])
  • condition1: the first condition to be evaluated.
  • value1: the value returned if condition1 is TRUE.
  • condition2, value2, …: more conditions and values, used if the first one is false.

In this order form, a bottle costs $60, or $50 for 10 or more. Shipping is $25, or free for orders above $150.

IFS(Quantity >=10 , 50, 60) * Quantity
IFS(Order amount > 150, 0, 25)
Order amount + Shipping fees

The first formula goes in Order amount, the second in Shipping fees and the third in Total amount. Full article

Next steps