Formula
This article explains how to create & work with a Formula field.
Create a formula field
- Click on
+icon to the right ofFields header - On the dropdown modal, enter the field name (Optional).
- Select the field type as
Formulafrom the dropdown. - Insert required formula
- Click on
Save Fieldbutton.
- You can use explicit numerical values/ strings as needed, e.g.
123(numeric) or"123"(string). - You can reference field names in equation with
{}, e.g.{field name} - Nested formula (formula equation referring to another formula field) is supported
Unlike other field types, formula cells cannot be modified by double-clicking since the value is generated based on the formula.
Supported formula functions
- Numeric and Logical Operators
- Numeric Functions
- String Functions
- Date Functions
- Array Functions
- Generic Functions
- JSON Functions
- Conditional Expressions