Formula and Functions*

EDITable features an Excel-like formula engine that supports over 50 functions, including logical, boolean, date, math, and others. The formula editor is intuitive and user-friendly and offers dynamic help suggestions regarding syntax and examples. It includes features like auto-complete and multi-line support to better assist users in creating and troubleshooting formulas.

✔️You can type the formula in the formula editor while setting up the default values that you want to derive from the data.

✔️You can also enter formulas and operators directly into the table's cells to perform calculations.

✔️Additionally, you can copy and extend the formulas to the cells below, similar to Excel's 'fill' feature. Please refer to the sections below for a detailed list of the formulas, functions, and operators available for calculations.

  • Conditional Statements

  • Logical Functions

  • Math Functions

  • Text Formatting Functions

  • Date functions

  • Other Operators

*This section is being updated. Some formulas and functions may not be currently available in the visuals or the docs. We appreciate your understanding and patience as we work to provide comprehensive information about these formulas and functions.

Last updated