Stackby consists of more than 25 columns to add in the table from that one is FORMULA column type. Formulas let you reference other columns in a table and create different functions based on the content of those tables.

In this article, we will learn 
1. How to write formula
2. Formatting of formula column type


Creating a formula column type


Add new column and choose formula as a column type

How to write a formula
Once you created formula column type, now you just need to add formula in “Type formula here” in this box

Please check the formula Terminology to learn how to format and use the formula functions

Formatting the result of a formula

Every formula results in some result - either a number, a date, or text - and how you can apply formatting to that result varies.

Formatting in any of

  • Integer

  • Decimal

  • Percent

  • String

  • Date

  • Currency