Formula

Create a formula field

1. Click on + icon to the right of Fields header
2. On the dropdown modal, enter the field name (Optional).
3. Select the field type as Formula from the dropdown.
4. Insert required formula
5. Click on Save Field button.

tip

• 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

note

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
• Conditional Expressions