Common Notion Formula Snippets

Copy-ready formula snippets for dates, people, text cleanup, status labels, and other everyday use cases.

This page collects small formulas that are useful in everyday work. Use it when you already know the situation and want to copy a formula directly.

Before copying a snippet, check your own property names first.

Scenario	Main functions used
Safely display a date	`empty()`, `formatDate()`
Safely display people	`map()`, `name()`, `join()`
Clean text	`trim()`, `replaceAll()`
Status labels	`ifs()`, `style()`

Safely display a date

if(empty(prop("Date")), "Not set", formatDate(prop("Date"), "YYYY-MM-DD"))

Safely display people

if(empty(prop("Members")), "Unassigned", prop("Members").map(current.name()).join("、"))

if(empty(prop("Project")), "No project", prop("Project").map(current.prop("Project Name")).join("、"))

Completed task ratio

lets(  Tasks, prop("Tasks"),  totalCount, Tasks.length(),  completedCount, Tasks.filter(current.prop("Status") == "Completed").length(),  if(totalCount == 0, 0, completedCount / totalCount))

Clean text

trim(replaceAll(prop("Text"), "\\s+", " "))

Join a list with Chinese enumeration commas

prop("Tags").join("、")

Extract numbers from text

match(prop("Text"), "\\d+")

Check whether a task is due this week

lets(  daysLeft, dateBetween(prop("Due Date"), today(), "days"),  daysLeft >= 0 and daysLeft <= 7)

Generate numbered text

Prefer the newer reference function:

format(prop("Number")).padStart(3, "0")

Compatible version:

substring("000" + format(prop("Number")), length("000" + format(prop("Number"))) - 3)

Multi-condition status label

ifs(  prop("Status") == "Completed", style("Completed", "green", "b"),  empty(prop("Due Date")), style("Unscheduled", "gray"),  prop("Due Date") < today(), style("Overdue", "red", "b"),  prop("Due Date") == today(), style("Today", "yellow", "b"),  style("In Progress", "blue"))

Common Snippets