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
You write a formula in a Notion database property, but instead of the expected value, the cell shows nothing at all. An empty string result often appears when the formula logic does not match the data type or when a function returns a blank value. This article explains the main reasons a Notion formula returns … Read more
Notion formulas work with a single line of code by default, but many calculations and text outputs require more than one instruction. A multi-line formula lets you chain logic, apply conditional formatting, or combine multiple operations in one property. This article explains how to write and structure a multi-line formula using the ifs(), if(), and … Read more
When you write a formula in a Notion database, you may see the error “Type Mismatch”. This happens because Notion formulas require all values in an operation to be the same data type. For example, you cannot add text to a number or compare a date with a string. This article explains why the type … Read more
Notion does not include a built-in function to calculate the number of working days between two dates. Business users often need this number for project timelines, sprint planning, or invoice tracking. This article explains how to build a formula that excludes weekends and optionally handles holidays. You will learn the exact formula structure, how to … Read more