Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

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?

Comments

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.

Sign in to join the Community!

Quick Links

Find more posts tagged with

Formulas