# Formulas

> Calculated fields in Formclick Databases, with the functions you can use.

Source: https://docs.formclick.io/databases/database-formulas

A **Formula** field computes its value from other fields in the same record. Refer to a field by its name in braces, like `{Status}`.

```
IF({Status} = "Won", "🎉", "")
CONCAT({First name}, " ", {Last name})
DATETIME_DIFF({Due date}, TODAY(), "days")
```

## Functions

| Kind | Functions |
| --- | --- |
| Logic | `IF`, `SWITCH`, `AND`, `NOT`, `ISBLANK`, `BLANK` |
| Text | `CONCAT`, `LEFT`, `RIGHT`, `MID`, `LEN`, `FIND`, `CONTAINS`, `SUBSTITUTE`, `TRIM`, `UPPER`, `LOWER`, `REPT`, `TEXT`, `VALUE` |
| Numbers | `SUM`, `AVERAGE`, `MIN`, `MAX`, `COUNT`, `ROUND`, `ROUNDUP`, `ROUNDDOWN`, `FLOOR`, `CEILING`, `ABS`, `MOD`, `POWER`, `SQRT` |
| Dates | `TODAY`, `NOW`, `DATEADD`, `DATETIME_DIFF`, `DATESTR`, `YEAR`, `MONTH`, `DAY`, `WEEKDAY`, `HOUR`, `MINUTE` |

Formulas recalculate automatically when the fields they use change. They never run code: they only work with the values in the record.