You want to calculate the number of days between two dates inside a Notion database. Notion formulas use a built-in function called dateBetween to return the difference in days, hours, minutes, or seconds. This article explains the correct syntax for the dateBetween function, shows how to handle empty or future dates, and covers common mistakes … Read more
Notion formulas can transform raw date values into readable text for reports, task boards, or project dashboards. Without formatting, a date property like Deadline appears as a full timestamp that is hard to scan. This article explains how to use the formatDate() function to convert dates into custom string formats. You will learn the syntax, … Read more
You are working on a Notion database formula and see the error message “Cannot Convert” instead of the expected result. This error occurs when a formula tries to change a value from one data type to another in a way that Notion does not support. This article explains the three main causes of this error … Read more
You want a Notion database property that automatically changes its displayed status based on values in other columns. For example, a task row should show “Overdue” when the due date is past and the task is not marked complete. Notion formulas can evaluate multiple conditions and return a custom text status. This article explains how … Read more
Notion Formula 2.0 introduces a rewritten formula engine that supports modern programming concepts like variables, functions, and conditional logic. If you have been using legacy formulas in your databases, you may notice that some old syntax no longer works or behaves differently. This article explains the new features step by step and shows you exactly … Read more
You have a Notion database where each page contains a number you want to total, and those pages are linked to a parent page through a relation property. Manually adding those numbers is slow and error-prone when the list grows beyond a few items. Notion does not have a built-in SUM function for related pages, … Read more
When you write a formula in a Notion database, you may see the error message “Argument Too Long.” This error occurs because Notion limits the total length of a formula to 5,000 characters. This restriction applies to the formula text itself, not the computed output. This article explains why the limit exists and provides practical … Read more
You want to show the current date inside a Notion database formula. Notion formulas do not have a built-in TODAY function like spreadsheet software. This limitation means you cannot get a live, auto-updating date directly from a formula property. This article explains the workaround using a linked date property and the now() function, and shows … Read more
When working with dates in Notion databases, you often need to reference the current date or time in your formulas. Two common functions for this are now() and today(). Many users are confused about which one to use because their names sound similar but they return different data types. This article explains the exact difference … Read more
Notion formulas allow you to manipulate text strings, numbers, and dates directly inside databases. The slice() function extracts a portion of a text string based on a starting and optional ending position. When you need to pull a first name from a full name, isolate a domain from an email address, or grab a specific … Read more