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