# Function Node

### Description

Use the Formula node to create new columns using spreadsheet-like formulas. You reference columns using their name, and formulas are applied automatically to all rows in the table. You have access to arithmetic operations, and a library of functions.

##### Example 1: Calculate payable tax on your profits

(revenue-cost)*(tax/100)

##### Example 2: Create full names from first and last names, removing extra whitespace

join(strip(first_name)," ",strip(last_name))

The formula editor will help you write your formulas with:

autocompletion for column names, functions and brackets

syntax highlighting to differentiate numbers, text, columns and functions

error checking (wavy red lines) for mistakes in your formulas

For the full documentation on functions, please reference the Functions References Documentation.

### Tips

Functions typically one work for one type of input (e.g. number, text, date & time). We're working on making this more explicit, with better error messages as well.

↩️ Back to Workflow Settings

Updated on: 05/10/2024

Thank you!