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.

✔️Type the formula in the formula editor while setting up the default values, derived from the data.

✔️ Use formulas while inserting a formula column.

The formulas can be:

• Conditional Statements

• Logical Functions

• Math Functions

• Text Formatting Functions

• Date functions

• Other Operators