Install

Functions

Blog

Pricing

About

back

SheetFlash Functions

File Processing

Merge Files

Split File

Text Extraction

Extract Segmented Strings

Extract Words

Extract by Regex

AI

Generative AI

Sheet Processing

Merge Sheets

Add Sheets

Delete Sheets

Data Analysis

Countifs

Sumifs

Date and Time

Convert Number to Date

Basic

Text

Copy and Paste

Clear

Native Formulas

Insert Rows/Columns

Delete Rows/Columns

Table Manipulation

Deduplicate

Expand

Fill Empty

Filter

Group

Sort

Text Processing

Insert Letters

Join Texts

Replace Words

Replace by Regex

Sort Letters

Trim

Join / Lookup

Lookup

Join Tables

SheetFlash Functions

File Processing

Merge Files

Split File

Text Extraction

Extract Segmented Strings

Extract Words

Extract by Regex

AI

Generative AI

Sheet Processing

Merge Sheets

Add Sheets

Delete Sheets

Data Analysis

Countifs

Sumifs

Date and Time

Convert Number to Date

Basic

Text

Copy and Paste

Clear

Native Formulas

Insert Rows/Columns

Delete Rows/Columns

Table Manipulation

Deduplicate

Expand

Fill Empty

Filter

Group

Sort

Text Processing

Insert Letters

Join Texts

Replace Words

Replace by Regex

Sort Letters

Trim

Join / Lookup

Lookup

Join Tables

SheetFlash Functions

File Processing

Merge Files

Split File

Text Extraction

Extract Segmented Strings

Extract Words

Extract by Regex

AI

Generative AI

Sheet Processing

Merge Sheets

Add Sheets

Delete Sheets

Data Analysis

Countifs

Sumifs

Date and Time

Convert Number to Date

Basic

Text

Copy and Paste

Clear

Native Formulas

Insert Rows/Columns

Delete Rows/Columns

Table Manipulation

Deduplicate

Expand

Fill Empty

Filter

Group

Sort

Text Processing

Insert Letters

Join Texts

Replace Words

Replace by Regex

Sort Letters

Trim

Join / Lookup

Lookup

Join Tables

Native Formulas

Updated at:

Apr 29, 2024

Category:

Basic

The Native Formulas is a feature that enables you to input a formula at the beginning of the targeted data range and then apply it to the entire selected range using autofill, streamlining the process of performing operations or calculations across multiple cells or rows.

See it in Action

Requirements

Data

Target Data
- Data Range: Identify the cells range where you want to apply the function.
- Fill the formula for the first cell: Input the formula that you want to apply for the first cell of the data range. The formula would be autofilled to the rest of the cells.