In a Notion database, you can add a formula property that lets you run all kinds of calculations and functions based on other properties. Just like in Excel or Google Sheets, you can use formulas in Notion to find sums and arrive at many other helpful values ⚗️
We know this can be complicated, so don't hesitate to reach out to us if we can help.
The hardest thing about writing formulas is understanding all the terminology! 😅 Here are the most common words you'll see when using formulas in Notion and what they mean:
- Function: A relation from a set of inputs to a set of possible outputs where each input is related to exactly one output.
- Syntax: Refers to the order of letters and terms in your formula to return the right value.
- Argument: Refers to any input in a function, like a property.
- String: Most often refers to text (i.e. a string of letters next to each other). Strings are always wrapped in quotation marks in formulas.
- A substring refers to a segment of a larger string. "No" is a substring of "Notion".
- Boolean: A boolean is either true or false.
- Concatenate: Combines two strings together.
concat("add", "text") would yield
Terminology in action
Here's an example to tie all of the above together:
concat is the function. It applies a certain calculation or action to the inputs contained in its parentheses.
"text" are arguments in that function.
- Each argument is text (otherwise known as a string).
- Functions can use a variety of different arguments, like checkboxes (also known as booleans), numbers or dates.
- Function syntax requires strings to be wrapped in quotes and its arguments to be contained within parentheses.