You see the error “Cannot convert number to date” in a Notion formula property and the expected date value does not appear. This error occurs when a formula returns a number but Notion expects a date data type. Notion formulas are strict about data types and do not automatically convert numbers to dates. This article … Read more
Notion formulas provide a slice() function that extracts a substring from a text property. When you need to extract characters from the end of a string, using a negative index for the end parameter lets you specify positions relative to the last character. This article explains how slice() interprets negative indices and how to use … Read more
When you write a Notion formula that tries to reference a property whose name includes a special character such as a hyphen, slash, apostrophe, or parenthesis, the formula often returns an error or fails to save. This happens because Notion’s formula syntax treats certain characters as operators or delimiters, breaking the reference. This article explains … Read more
You want to estimate task effort in Notion but need to account for uncertainty or risk. A simple hours field does not capture the extra time that complex or high-risk tasks require. By adding a risk multiplier to your effort formula, you can calculate a weighted estimate that reflects both the base work and the … Read more
When you build a Notion database formula that needs to show different results depending on who created or owns a page, you may discover that the formula property does not directly expose the page owner field. This limitation occurs because the formula property can read only other database properties, not system-level metadata like the Created … Read more
Notion formulas let you filter and test data inside a database. The every() and some() functions check whether all or at least one item in an array meets a condition. Without these functions, you would need to write complex nested logic to test multiple values. This article explains how to use every() and some() with … Read more
You have created a Notion formula that calculates exactly the value you need, but when you try to set that formula as a default value for another database property, Notion refuses. This limitation exists because Notion formulas are computed dynamically based on other property values, not stored as static data. A default value must be … Read more
You want to track goal progress in Notion using a formula that automatically calculates completion based on milestones. Notion formulas can sum checkbox values, count completed dates, or evaluate status properties to produce a percentage. This article explains how to build a Notion formula that converts milestone completion into a visual progress bar or percentage. … Read more
You just upgraded a Notion database formula to Formula 2.0 and now the formula shows an error or returns blank results. This happens because Formula 2.0 uses a different syntax for referencing database properties compared to the legacy formula engine. The old property reference format no longer works after migration. This article explains why the … Read more
Notion formulas can pull values from a related database, but applying the min() or max() function to sub-items within that relation is not obvious. The min() and max() functions work on a list of numbers in the same database, not directly on values from a related table. This article explains how to use rollups combined … Read more