Formulas and Databases

Reference

Formula Examples

Converting Data Types

Learn how to convert data to another type in a Notion formula.

Notion formulas can only return data of a single type. For reference, Notion formulas work with four distinct data types:

Therefore, you'll often need to convert data from one type to another in order to get your formula to work.

Here are all the methods you can use to convert data to another type.

To numbers:

To Booleans:

Function/Method

Example

`if(prop("Text") == "true", true, false)`

To strings:

Function/Method

Example

`format(42)`

To Booleans:

Function/Method

Example

`if(prop("Num") == 42, true, false)`

To dates:

Function/Method

Example

`fromTimestamp(prop("Num"))`

To strings:

Function/Method

Example

`format(true)`

To numbers:

To strings:

To numbers:

To Booleans:

Function/Method

Example

`if(prop("Date") == now(), true, false)`

β My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.

Copy link

On this page

Converting Strings

Converting Numbers

Converting Booleans

Converting Dates