Formulas & Functions

PowerTable 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 use formulas while setting up default values derived from the data and while inserting a formula column.

The formulas can be classified into,

  • Conditional Statements

  • Logical Functions

  • Math Functions

  • Text Formatting Functions

  • Date functions

  • Other Operators

Last updated