Red Gregory

View Original

How To Find Missing Values In A Notion Database

Caution: The input of '0' is considered "empty."

What The Empty And Test Functions Do

Empty: Locates an empty cell.

syntax:

empty(number)
empty(text)
empty(boolean)
empty(date)

Test: Locates a particular value in a cell.

example:

test("1-2-3", "-") == true


Empty Function Example:

Missing Value Formula:

if(empty(prop("Name")), true, if(empty(prop("Inventory")), true, if(empty(prop("Shipped")), true, if(empty(prop("Delivered")), true, false))))

Identify Page Of Missing Value(s)

Step 1: Insert Missing Value Formula

if(empty(prop("Name")), prop("Name"), if(empty(prop("Inventory")), prop("Name"), if(empty(prop("Shipped")), prop("Name"), if(empty(prop("Delivered")), prop("Name"), ""))))

Step 2 (optional): Filter

Missing Value :: Is not empty

VIEW EXAMPLE


See this gallery in the original post