How to autopopulate a column with formulas such that when a new line is inserted, it is automaticall

Christopher Grinde

How to autopopulate a column with formulas such that when a new line is inserted, it is automatically filled in and calcuated?

Kara Lumley

Hi Christopher,

You'll see the formulas populate automatically when:

• Typing into a newly inserted or a blank row directly in between two others that have the same formula applied.
• Typing into a newly inserted row at the very top of the sheet, if it's above two others that have the same formula applied. This includes rows inserted via web form.
• Typing into a newly inserted or blank row at the very bottom of the sheet, if it's below two others that have the same formula applied. This includes rows inserted via web form.