Notion Templates
Notion Templates/
All Templates
All Templates/
🚡
Find Missing Values
🚡

Find Missing Values

Master Tag
Tips & Tricks
Created
Apr 8, 2020 07:15 PM
How It Works
https://www.redgregory.com/notion/2020/4/9/find-all-missing-values-in-a-notion-database
Usage
If Nested
True
false
empty
Web Tags
Formula
Database
How To
Alternatives
Cover
⚠️
Caution: The input of '0' is considered "empty."
 
Missing Values
Name
Inventory
Shipped
Delivered
Missing Value?
Entry 1
24
Yes
Entry 2
14
Pending
No
Entry 3
36
Yes
No
Entry 4
56
No
No
Entry 5
No
Entry 6
Yes
Yes
Entry 7
34
No
Entry 8
19
No
Pending
Entry 9
24
Pending
No
Entry 10
64
Yes
Yes
Entry 11
Pending
Pending
Entry 12
73
No
Entry 13
80
No
No
Entry 14
12
Pending
No
Entry 15
10
Yes
Yes

Identify Page Of Missing Value(s)

 
Missing Values
Name
Inventory
Shipped
Delivered
Missing Value?
Entry 1
24
Yes
Entry 5
No
Entry 6
Yes
Yes
Entry 7
34
No
Entry 11
Pending
Pending
Entry 12
73
No