*Enroll in **Supercharge your Productivity with Notion** by May 6!*

Youâ€™ve taken the plunge. After hearing about the buzzy productivity tool called Notion, you migrated from Evernote and are excited for this new chapter in note-taking. Youâ€™ve mastered the basics of Notion, have set up a GTD to-do list, and even created a Personal Wiki. And as you sit down to write your first **If Statement**, you expect to see a familiar Excel-like layout and it hits you: Where are the cells? Why donâ€™t these property types align? And why do these formulas look so different?

At first glance, Notion formulas are not as intuitive as their Google Sheets counterparts. In this post weâ€™ll list and explain the formula property type, operators, functions and share common formula examples that you can then use in your own workspaces.

## Notion formulas: a reference guide

When you create a new formula, there are four options to choose from: **Properties, Constants, Operators and Functions.**

**Properties:**These are effectively your â€śvariables.â€ť**Operators:**Simple calculations like arithmetic (add/subtract) and logic (true/false).**Functions:**More complex, pre-defined formulas that resemble what youâ€™re used to seeing in Google Sheets or Microsoft Excel.**Constants**: Common constants likeor**pi**. (You probably wonâ€™t use these often.)**e**

## Property Types (or Variables)

The first odd thing youâ€™ll notice is that since Notion acts as a database, it doesnâ€™t have variables, you canâ€™t access an individual cell. This makes calculations like financial modeling and local variables (i.e. a variable that applies to just one row) very challenging. In Excel terms, this means that you can only apply formulas to an entire column (a la *copy and paste down*).

In front of each **property**, youâ€™ll see an icon denoting its type (*number, text, date*). This is important because youâ€™ll match this up with **functions** (which have also have these same icons) to ensure that your calculation is *apples-to-apples*. For example, the **dateBetween** function returns a **number **whereas the **dateSubtract** returns a date. **This is a common source of error.**

## The different types of functions

If youâ€™re using Notion as a comprehensive productivity system youâ€™ll probably draw from a similar pool of operators and functions.

The most common functions

Adam Listek kindly aggregated all of Notionâ€™s functions into this massive cheat sheet.

## Common formula use cases (that you can copy!)

**Basic Math (Fahrenheit to Celsius)**

A *very* simple example on how to use **Property Types** as variables.

**Basic Logic** **Operators**

Using the **==** operator to compare two numbers and then the **equal()** formula for two texts (or strings).

**Basic If statements**

Using a basic **If statement** to test and show the greater of two numbers.

**Nested If statement**

Hereâ€™s a more advanced **nested If statement** to convert a text-based tag (*Monthly)* into a number (30). This forms the basis for a lot of Notionâ€™s task-management capabilities and is a powerful trick to apply across your pages.

**Testing if a date is overdue**

Another common test (using the **=** operator) to see if a task is overdue.

**Creating a review frequency**

This formula is inspired by David Allenâ€™s GTD, combining an **if statement, **the **dateAdd** function and **now()** to test if an action (i.e. calling a friend in your CRM) falls outside the review window.

**Combining a number and a string**

If you want descriptive text that uses the output of a formula hereâ€™s how to use the **concat** function to display the *number of days* a task has been overdue. It requires you to convert a number into text (a *string*) using the **format** fuction. The video shows how it can be helpful to â€śleg intoâ€ť your formulas as the nesting can make things tricky.

**Visual Progress bars**

These progress bars compare two numbers (say, 1 and 100) and visually show your progress. Theyâ€™re beyond the scope of this tutorial, but savvy Notioner Ben Smith has an excellent tutorial.

## Download these formulas into your Notion workspace

The beauty of Notionâ€™s block system is that you can duplicate any of these formulas and tables into your own workspace. And for more Notion resources check out our YouTube playlist and blog archive.