Formulas 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: 02/21/2025