Notion Formula Returns Empty String: Common Causes

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 an empty string and shows how to check and fix each cause.

Why a Notion Formula Returns an Empty String

Notion formulas evaluate from left to right and return a single value. When a formula returns an empty string, it means the final expression produced a blank text value. The most common technical root cause is an if() statement that does not cover all possible cases. For example, if(prop("Status") == "Done", "Complete") returns an empty string when the status is not “Done” because the third argument (the else value) is missing. Notion defaults to an empty string when no else value is provided.

Another frequent cause is a type mismatch. Notion treats numbers and text as different data types. A comparison like prop("Count") > "5" always fails because a number cannot be greater than a string. The formula then falls to the else branch, which may be empty. Similarly, referencing a property that does not exist or has a renamed label returns an empty string because Notion cannot find the data source.

A third cause involves functions that return blank values by design. The empty() function checks if a value is empty and returns true or false, but if used inside an if() without a proper else, the result can be an empty string. The replace() and slice() functions can also return empty strings when the start index is out of range or the search string is not found.

Steps to Diagnose and Fix an Empty String Formula

Follow these steps in order to find the exact cause of an empty string result. Each step covers a specific scenario.

Check the if() Statement for Missing Else Value

1. Open the database property editor
   Click the three-dot menu next to the formula property name and select Edit property. The formula editor appears.
2. Locate every if() function
   Look for if(condition, value_if_true, value_if_false). If the third argument is missing, add it. For example, change if(prop("Priority") == "High", "Urgent") to if(prop("Priority") == "High", "Urgent", "Normal").
3. Test the formula
   Click Done and check a row where the condition is false. The cell should now show the else value instead of an empty string.

Verify Property Names and Data Types

1. Open the formula editor
   Click the three-dot menu on the formula property and select Edit property.
2. Check each prop() reference
   Make sure the property name inside the parentheses matches exactly the name on the database column. Notion property names are case-sensitive. For example, prop("Due Date") is different from prop("due date").
3. Inspect the data type of each property
   Hover over the property name in the database header. The type is shown in a tooltip. If the formula expects a number but the property is a text field, convert the text to a number using toNumber(prop("Field")) before performing arithmetic.

Test Functions That Can Return Blank Values

1. Review slice() and replace() calls
   If you use slice(prop("Text"), 0, 5), confirm that the text is at least 5 characters long. If the text is shorter, slice returns an empty string. Wrap the function in an if() to handle short text: if(length(prop("Text")) >= 5, slice(prop("Text"), 0, 5), prop("Text")).
2. Check empty() usage
   If you use if(empty(prop("Field")), "Missing"), add a third argument for when the field is not empty: if(empty(prop("Field")), "Missing", prop("Field")).

If Notion Still Shows an Empty String After the Fix

Formula returns empty only on new rows

If existing rows work but new rows show empty, the formula references a property that does not exist on the new row. Check that all referenced properties are present in the database. Add any missing property columns.

Formula works in one view but not another

A filtered view may hide rows that cause the formula to return empty. Remove all filters from the view and check the formula again. If it works, the formula is correct and the view filter is hiding the rows.

Formula returns empty after renaming a property

If you rename a property in the database, formulas that used the old name break and return empty strings. Edit each formula and update the property name in the prop() function to match the new name.

Notion Formula Functions That Commonly Produce Empty Strings

Function	Returns Empty When	Fix
if() without else	Condition is false and no third argument is given	Add a default value as the third argument
slice()	Start index is beyond the string length	Check length before slicing
replace()	Search string is not found	Use if(contains()) to verify before replacing
format()	Input is already empty or null	Check for empty input with empty() before formatting

If you have covered all the checks above, the formula should return the expected value. Test each function individually by creating a temporary formula property that outputs only the result of that function. This isolates the part of the formula causing the empty string. As an advanced tip, use the test() function in Notion to debug intermediate values: test(prop("Field"), "Field value is: ") displays the raw value of a property inside the formula editor, helping you confirm the data type and content before the main logic runs.