Fix Notion Formula Cannot Toggle Output Based on Page Owner

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 By or Last Edited By fields. This article explains why this restriction exists and provides a reliable workaround using a helper property to capture the owner’s identity.

Why Notion Formulas Cannot Access the Page Owner Directly

Notion formulas operate only on database properties that appear as columns in the database view. The Created By and Last Edited By fields are system properties stored outside the column schema. A formula cannot call prop(“Created By”) because that property name is not a valid column reference in the formula editor.

The Created By property shows the user who created the page, but it outputs a person object type. Notion formulas support only text, number, date, checkbox, and select values as inputs. Person objects are not a supported formula input type. Even if you could reference the Created By column, the formula would have no way to compare it to a specific user name.

To work around this limitation, you must create a helper property that stores the owner’s name as a text or select value. The formula can then read that property and use conditional logic to toggle its output.

Steps to Toggle Formula Output Based on Page Owner

The following steps assume you have a Notion database with existing pages. You will add a helper property, populate it with the owner’s name, and write a formula that checks that property.

1. Add a Select property for the owner
   Open your database and click the + button in the last column header. Select Select from the property type list. Name it Owner. This property will store the name of the page owner as a select option.
2. Create a select option for each owner
   Click inside the Owner cell on any page. Type the name of the page owner (for example, Alice or Bob). Press Enter to create the option. Repeat this for every person who owns pages in this database. Each owner name becomes a reusable select option.
3. Set the Owner value on each page
   Go through every page in the database. For each page, click the Owner cell and select the correct owner name from the dropdown. If you have many pages, consider using a database template that pre-fills the Owner field with the current user. To do this, edit the database template, add the Owner property, and set the default value to the appropriate person.
4. Add a Formula property
   Click the + button in the last column header again. Select Formula from the property type list. Name it Owner Toggle or any name you prefer.
5. Write the conditional formula
   Click into the formula editor for the new Formula property. Enter a formula that uses the if() function to check the Owner property. For example, to show “Admin View” for Alice and “User View” for everyone else, use:
   if(prop("Owner") == "Alice", "Admin View", "User View")
   Replace Alice with the exact select option name you created in step 2. The formula compares the value of the Owner property to the text string. If they match, the first output appears. Otherwise, the second output appears.
6. Test the formula on multiple pages
   Click out of the formula editor. The formula column will display the appropriate output for each page based on the Owner value. Change the Owner on a test page to confirm the formula updates correctly.

If Notion Still Has Issues After the Main Fix

Formula Shows “Invalid syntax” error

The most common cause is a mismatch between the select option name in the database and the text string in the formula. Open the Owner property on any page and copy the exact option name, including spaces and capitalization. Paste that name between the quotation marks in the formula. Ensure there are no extra spaces after the equal sign.

Formula output does not change when I update the Owner field

Formulas recalculate automatically when any property they reference changes. If the output does not update, the formula may be referencing a different property name. Open the formula editor and confirm that prop(“Owner”) matches the exact name of your helper property. If you renamed the property after writing the formula, the reference breaks. Edit the formula to use the current property name.

Multiple owners need different outputs

The if() function supports nested conditions. To handle three or more owners, use:
if(prop("Owner") == "Alice", "Admin", if(prop("Owner") == "Bob", "Editor", "Viewer"))
Each additional owner requires another nested if() statement. For more than five owners, consider using a separate database with a lookup relationship to keep the formula readable.

I want the formula to use the actual page creator, not a manually set value

Notion does not expose the Created By value to formulas. The manual Owner property is the only reliable method. To reduce manual work, create a database template that includes the Owner property and set a default value. When a user creates a new page from that template, the Owner field is already filled with their name. This approach eliminates the need to update the Owner field on every new page.

Manual Owner Property vs Automation Alternatives

Item	Manual Owner Select Property	Automation via Third-Party Tool
Setup effort	Low — add one property and set values per page	Medium — requires API connection and script
Maintenance	Manual update when owner changes	Automatic sync with user database
Formula compatibility	Works directly with if() and other functions	Output must be written to a property that formula can read
Cost	Free	May require paid plan for tool like Zapier or Make

The manual Owner property is the simplest solution for most databases. Automation tools can write the page creator into a property automatically, but they require setup and ongoing maintenance. For a single database with fewer than 50 pages, the manual method is faster to implement.

You can now create a Notion formula that toggles its output based on the page owner by using a helper Select property and the if() function. Start by adding the Owner property to your database and filling it with the correct names. Then write a formula that checks prop(“Owner”) and returns the desired text, number, or date. For databases with many pages, use a template to pre-fill the Owner field and reduce manual data entry.