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! Pages with 🚀 present more advanced formulas.
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
Checking if date falls within last week, next week or this week
‣
Relations
Percentage of tasks completed (completion rate without a rollup)
🚀 Top 3 team members with the most active tasks
🚀 Next task due in line (displayed in related projects database)
‣
API
Get database page ID for API
‣
Number
Separate thousands with commas