Notion Formulas

Need help with Notion formulas but don't have time to read through documentation? Here are some of the most commonly used formulas in action. Simply copy and paste them into your database formula property, adjust the properties (e.g.prop("Date")), and you're all set! To understand Notion formula syntax, refer to this page.

‣

Text

Break line with "\n"

Change formatting of a formula: color & styling

Calculate String Length: Count Characters in Text

Combine multiple text strings

Change text to upper or lower case

Get Word Count

‣

Date

Check the day, month, or year from a date property

Get quarter and year from date property

Check if date was yesterday

Calculate total hours, minutes, or days in a date range

Show days left until deadline and if task is overdue

Calculate business days within a date range

Check age category (child, adult, or senior) from birth date

Calculate age based on birth date

‣

Relations

Look up any property in a related database (without a rollup)

Percentage of tasks completed (completion rate without a rollup)

Check the next task in line (displayed in related projects database)

Due date of the next task in line (displayed in related projects database)

‣

API

Get database page ID for API

‣

Number

Separate thousands with commas