177 Formula demo
⚗

177 Formula demo

Tags
FormulaDemo
Date
February 19, 2020
Related Tutorial
⚗
No.27 formula-1：公式组成和特性（Formula Structure Characteristic）
⚗
No.28 formula-2：字符串格式（Formula Format String）
⚗
No.29 formula-3：数字格式（Formula Format Number）
⚗
No.30 formula-4：日期格式（Formula Format Date）
⚗
No.31 formula-5：复选框格式（Formula Format CheckBox）
⚗
No.32 formula-6：If 函数（Formula If）
⚗
No.33 formula-7：常用推荐：倒计时（Formula Recommend Countdown）
⚗
No.34 formula-8：常用推荐：关联进度条（Formula Recommend Progress）
⚗
No.35 formula-9：常用推荐：多进度条（Formula Recommend Progress）
⚗
No.36 formula-10：日期过滤 & 归档 （Formula Date Filter Archive）
💡
1️⃣ 点击右上角Duplicate 即可复制到你的 Notion 左侧面板目录中。 ———————————————————————————————————————— Click Duplicate in the upper right to copy the current page to your Notion.
💡
2️⃣ 我的 Notion 主页/My Notion Home →
177
177
💡
3️⃣ Notion 中的 formula 列表中文说明和个人使用情况 →
⚗
Notion formula table by 177
💡
4️⃣ 原始教程/Tutorial list →
Notion tutorial lite_
Notion tutorial lite_

⚗
No.27 formula-1：公式组成和特性（Formula Structure Characteristic）

No.27 demo A

NameXYZAll in 1
No.27_A
1
2
3
7

No.27 demo B: Time progress

Name开始/StartEnd时间进度/ProgressAll in 1已过天数/Days总天数/Total
2020s
January 1, 2020
January 1, 2021
3.221311475409836
3.221311475409836
1179
366
February 11, 2020
May 9, 2020
12.931818181818182
12.931818181818182
1138
88

⚗
No.28 formula-2：字符串格式（Formula Format String）

No.28 demo A

Name
28_A

⚗
No.29 formula-3：数字格式（Formula Format Number）

No.29 Demo A

NameN1F1F2F3N2
20
0.2
3.75
20%
100
177
1
3.75
100%
177
NaN
3.75
%

⚗
No.30 formula-4：日期格式（Formula Format Date）

No.30 Demo A

NameDate1F1F2F3Date2F22
January 1, 2020 → January 1, 2021
January 1, 2020 12:00 AM2023-03-25T16:53:05+00:00 → January 1, 2021 12:00 AM2023-03-25T16:53:05+00:00
February 25, 2020 4:00 PM2023-03-25T16:53:05+00:00
March 25, 2023 12:35 PM2023-03-25T16:53:05+00:00
NaN
February 26, 2020
February 26, 2020 12:00 AM2023-03-25T16:53:05+00:00
February 25, 2020 4:00 PM2023-03-25T16:53:05+00:00
March 25, 2023 12:35 PM2023-03-25T16:53:05+00:00
February 29, 2020
1582934400000
March 25, 2023 12:35 PM2023-03-25T16:53:05+00:00
February 25, 2020 4:00 PM2023-03-25T16:53:05+00:00
March 25, 2023 12:35 PM2023-03-25T16:53:05+00:00
NaN

⚗
No.31 formula-5：复选框格式（Formula Format CheckBox）

No.31 Demo A

NameC1F1F2No.31 Demo B
31_A1
31_B1
31_A2

No.31 Demo B

NameNo.31 Demo ARollupF1
31_B1
31_A1
true

⚗
No.32 formula-6：If 函数（Formula If）

No.32 Demo A

NameN1F1N2F2N3F3
33_A1
177
Yes
188
N1
188
N1
33_A2
188
No
177
N2
188
N2
33_A3
188
No
188
No
188
No

No.33 formula-7：常用推荐：倒计时（Formula Recommend Countdown）

视频中的原始页面/Original page in video →
⚗
No.33 formula-7：常用推荐：倒计时（Formula Recommend Countdown） 🌐️

No.33 Countdown Demo A

NameDF1F2F3F4F5F6Now
愚人节
April 1, 2020
-1088
🚧已过1088天
-26124
-1088
🚧已过1088天
🚧已过1088天
March 25, 2023 12:35 PM2023-03-25T16:53:05+00:00
国庆节
October 1, 2020
-905
🚧已过905天
-21732
-905
🚧已过905天
🚧已过905天
March 25, 2023 12:35 PM2023-03-25T16:53:05+00:00
元旦
January 1, 2020
-1179
🚧已过1179天
-28308
-1179
🚧已过1179天
🚧已过1179天
March 25, 2023 12:35 PM2023-03-25T16:53:05+00:00
明天/tomorrow
March 13, 2020
-1107
🚧已过1107天
-26580
-1107
🚧已过1107天
🚧已过1107天
March 25, 2023 12:35 PM2023-03-25T16:53:05+00:00
无日期/empty
NaN
🚧已过天
NaN
NaN
🚧已过天
🚧已过天
March 25, 2023 12:35 PM2023-03-25T16:53:05+00:00
今天/today
March 12, 2020
-1108
🚧已过1108天
-26604
-1108
🚧已过1108天
🚧已过1108天
March 25, 2023 12:35 PM2023-03-25T16:53:05+00:00

No.34 formula-8：常用推荐：关联进度条（Formula Recommend Progress）

视频中的原始页面/Original page in video →
⚗
No.34 formula-8：常用推荐：关联进度条（Formula Recommend Progress） 🌐️

No.35 formula-9：常用推荐：多进度条（Formula Recommend Progress）

视频中的原始页面/Original page in video →
⚗
No.35 formula-9：常用推荐：多进度条（Formula Recommend Progress） 🌐️

No.35 Progress Demo A

NameTypeDateF7F1F2F3F4F5F6
Day
⭐️️
■■■■■ 52.43%
0.5243055555555556
0.8064516129032258
3.221311475409836
NaN
%
■■■■■ 52.43%
Month
🌙
■■■■■■■■ 80.64%
0.5243055555555556
0.8064516129032258
3.221311475409836
NaN
%
■■■■■■■■ 80.64%
Year
🌞️
■■■■■■■■■■ 322.1%
0.5243055555555556
0.8064516129032258
3.221311475409836
NaN
%
■■■■■■■■■■ 322.1%
Customize（21st century）
☁️️
January 1, 2000 → December 31, 2099
■■ 23.22%
0.5243055555555556
0.8064516129032258
3.221311475409836
0.23229997551077525
■■ 23.22%
■■ 23.22%
No Date
☁️️
%
0.5243055555555556
0.8064516129032258
3.221311475409836
NaN
%
%
2H
☁️️
March 20, 2020 3:00 PM (GMT+8) → March 20, 2020 5:00 PM (GMT+8)
⛔️️ 已过期
0.5243055555555556
0.8064516129032258
3.221311475409836
13198.791666666666
⛔️️ 已过期
⛔️️ 已过期

No.35 formula-9：常用推荐：多进度条（Formula Recommend Progress）

视频中的原始页面/Original page in video →
⚗
No.36 formula-10：日期过滤 & 归档 （Formula Date Filter Archive） 🌐️

No.36 Demo A: days left

NameDatedays left
@March 19, 2020
March 19, 2020
-1101
@March 20, 2020
March 20, 2020
-1100
@March 21, 2020
March 21, 2020
-1099
@March 22, 2020
March 22, 2020
-1098
@March 23, 2020
March 23, 2020
-1097
@March 24, 2020
March 24, 2020
-1096
@March 25, 2020
March 25, 2020
-1095
@March 26, 2020
March 26, 2020
-1094
@March 27, 2020
March 27, 2020
-1093
@March 28, 2020
March 28, 2020
-1092
@March 29, 2020
March 29, 2020
-1091
@March 30, 2020
March 30, 2020
-1090
@March 31, 2020
March 31, 2020
-1089
@April 1, 2020
April 1, 2020
-1088
@April 2, 2020
April 2, 2020
-1087
@April 3, 2020
April 3, 2020
-1086
@April 4, 2020
April 4, 2020
-1085

No.36 Demo B: Basic Archive

NameArchivedLast Edited
A
Apr 28, 2020 2:41 PM
B
Apr 28, 2020 2:41 PM
C
Apr 28, 2020 2:41 PM

No.36 Demo C: Daily Checklist

NameABCDateStatus
1
March 2, 2020
🔒️ 已过期/Expired
2
March 12, 2020
🔒️ 已过期/Expired
3
March 27, 2020
🔒️ 已过期/Expired
4
March 28, 2020
🔒️ 已过期/Expired
5
⏺ TBD
6
⏺ TBD