Sign up for free
Functions

AUTOFILL

Automatically fills the whole column with formulas based on the column on the left column or the range defined by you.

Parameter List

Syntax
AUTOFILL(label, formula, 
[mode]
, 
[range]
)
label

The label or header of the column. It is added to the cell where the function is executed. For example: Email.

formula

The formula of the first cell to be filled automatically. For example: FIND_DOMAIN(A2).

[optional] mode

The behavior of the function. Choose either:

  • 0 (default) to fill only empty cells.

  • 1 to overwrite and recompute only if formula is different.

  • 2 to overwrite and recompute all cells.

[optional] range

Which column or range determines the length of the Autofill.

More details

The formula parameter should get the right formula for the first cell of the row or column you want to fill automatically.

Examples

AUTOFILL("Email", FIND_EMAIL_HUNTER(C2,A2,B2), 0, A:C) returns adds the FIND_EMAIL formula to cells D2 and D3.