177 Formula demo

177 Formula demo

💡
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_A2

No.31 Demo B

NameNo.31 Demo ARollupF1
31_B1
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