SeaTable offers you many different functions that you can add to your table. One of them is the so-called formula column. Using formulas you can link values from different columns and create different functions based on the data types of these columns.
Among other things, you can calculate with values in a row , merge them or relate them to each other.
Create a formula column
To apply a formula, you must first add a new formula column to your table. You can learn how to do that here.
SeaTable provides you with a formula editor to help you enter formulas.
Write a first formula
Once your formula column is created, you can start writing the formula. The following figure shows a simple formula to calculate the average of five numbers.
This formula always writes the static value 13.2 into the formula column as the result. However, the true power of the formula column only comes into its own when you use the values of other columns for your formula. With the {column name} in curly brackets you can reference existing columns in your table.
Then you can insert certain constants, operands and functions into your formula to calculate with, merge or relate the values of the different columns.
Clear color language
To be able to distinguish the different elements of your formula from each other, they are marked in a different color depending on their type:
| Object | Example |
|---|---|
| Functions |  |
| Text / String |  |
| Numbers |  |
| Column references |  |
Formula examples
Below are a few examples that illustrate the utility and use of formulas.
- Formula example: Simple multiplication with a formula
- Formula example: Merging text columns using a formula
- Formula example: Logical if operators for comparing values
- Formula example: Calculate the duration of a vacation
- Formula example: Calculate days until an event
- Formula example: Search for a word in a text
Mathematical conventions also apply in SeaTable
Of course you can rely on the fact that mathematical conventions also find their application in the formulas of SeaTable. Here are the most important examples:
- You can nestfunctions within each other using parentheses. Example: (( 1 + 2 ) * 3)
- Dot before dash, the order of parentheses and other mathematical rules are taken into account in SeaTable.
Formula column formatting
You can format the results in the formula column. Each formula in SeaTable has a number, a date or a text/string as result. Therefore, depending on this, you have different format settings available.
