How to use this guide 📌
Welcome to the Notion State Formula Guide! On the left, you’ll see a list of all of the functions available in Notion Formulas. This is meant to be a “Cheat Sheet” for information on Formulas, especially as you’re learning them. We found that while we were learning formulas, we knew how they worked but we needed to see a list of all of our available functions or “building blocks” that we could work with. We especially needed to know what each one required and what each one returned. This guide is perfect for that. We may expand it to more in depth teaching, let us know if that would be beneficial to you! We provide some basics below in “Formulas 101.” You can also see a template of what each page contains below and what each section is meant to describe.
← The Menu 🤔
There are different view options to make finding what you’re looking for as easy as possible. The default view is grouped by what each function returns which is usually what you’ll be looking for. You’ll know what you want your formula to give you and so this way, you can quickly see all of your available options. Because some functions can return multiple data types (see below for explanation of “Data Types”), you’ll see a function under multiple groups. They are exactly the same page, no different. Each one contains a standard setup that includes useful information for how to use that function in a formula.
- Alphabetical: Lists all functions in alphabetical order.
- Returns: Lists all functions by the Data Type they return.
Formulas 101 ✨
Data Types: There are 4 “types” of data (also called Values) that you need to be aware of when you create formulas - Strings, Numbers, Dates, and Booleans.
Strings: Basically just text. It can also include numbers but Notion will treat it as a “string” of characters.
Numbers: No letters allowed. You’ll want to make sure you’re using this type when performing calculations.
Dates: A single specific time in the past, now, or future.
Booleans: True or False, often shown as a checkbox.
A formula can handle as many functions as you like and as many different data types as you like. But when a formula doesn’t work or isn’t accepted by the editor, it’s oftentimes because the user is trying to do something like perform a calculation on what looks like a number but is really a string. Each function requires a certain data type and then returns a certain data type. That’s why it’s important that you understand each and we’ve included them in every function listed.
Syntax: Formulas are perfectly precise. There is no room for interpretation, it either works or it doesn’t, and it only works one way. They are essentially calculations. This means that missing one parentheses, comma, or quotation will cause the formula to not work. And not only not work, but since the editor only accepts working formulas, if you close out of the editor with a formula in progress that didn’t get accepted, you’ll lose what you wrote.
Template of Function Pages
Name of Function( )
-Notion's description of function.
- Requires: # of
- Type of
- Type of
- Returns: Type of returned
Possible variances of the function
a function example and operator example if applicable.
the actual code entered in the formula.
what the formula spits out