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
Notion formulas can count text in two ways: characters and words. The length() function returns the number of characters in a string, including spaces and punctuation. Many users assume it counts words, which leads to incorrect results in databases, task trackers, or content summaries. This article explains the difference between character count and word count … Read more
You want to show a progress percentage in a Notion database, such as the completion rate of tasks in a project or the fill rate of properties in a contact list. Notion does not have a built-in progress bar widget, but you can create one using a formula property. This article explains how to build … Read more
You have a Notion formula property that needs to pull data from a different database, but the formula editor only lets you reference properties from the current database. This restriction exists because Notion formulas operate on a single row and cannot directly query other databases or tables. This article explains why the limitation exists and … Read more
Notion formulas let you perform calculations on numbers stored in database properties. The round, floor, and ceil functions control how decimal numbers are converted to integers. Each function uses a different rule for rounding. This article explains how each function works, how to write the formula syntax, and where to apply them in a Notion … Read more