Skip to main content
FLO.W 思流Notion Formulas
Formula Snippets

Common 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.

ScenarioMain functions used
Safely display a dateempty(), formatDate()
Safely display peoplemap(), name(), join()
Clean texttrim(), replaceAll()
Status labelsifs(), 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"))

To use these formulas directly in task reminders, project progress, note heatmaps, and reports, continue with FLO.W Notion Template.

Last updated on