Google Sheets Formulas in Forms

Consider the guidelines in this topic while using Google Sheets formulas in forms.

• You can create Google Sheets formulas in form cells inside or outside the grid if the cells are not read-only or locked.

• Cells that contain cell text can contain Google Sheets formulas, but cells containing supporting detail (such as Oracle Fusion Cloud Enterprise Performance Management cells) cannot.

• Formulas are preserved in forms when you refresh the form even without saving the data.

• If you move a referential formula, its cell references are updated to reflect the new location.

• A cell with formula displays the dirty cell style if the value in the cell reference, present either in the same sheet or another sheet, is updated. On submitting, the updated value in the formula cell also gets submitted.

• In forms, you are prompted to save the spreadsheet as an Google Sheets file if you do any of the following (but you temporarily lose access to the form):

  • Change the current page

  • Select a different form

  • Connect to a different data source