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
1
2
3
7

No.27 demo B: Time progress

Name开始/StartEnd时间进度/ProgressAll in 1已过天数/Days总天数/Total
January 1, 2020
January 1, 2021
3.748633879781421
3.748633879781421
1372
366
February 11, 2020
May 9, 2020
15.125
15.125
1331
88

No.28 formula-2:字符串格式(Formula Format String)

No.28 demo A

Name

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 AM2024-03-28T15:29:31+00:00 → January 1, 2021 12:00 AM2024-03-28T15:29:31+00:00
February 25, 2020 4:00 PM2024-03-28T15:29:31+00:00
October 4, 2023 7:12 AM2024-03-28T15:29:31+00:00
NaN
February 26, 2020
February 26, 2020 12:00 AM2024-03-28T15:29:31+00:00
February 25, 2020 4:00 PM2024-03-28T15:29:31+00:00
October 4, 2023 7:12 AM2024-03-28T15:29:31+00:00
February 29, 2020
1582934400000
October 4, 2023 7:12 AM2024-03-28T15:29:31+00:00
February 25, 2020 4:00 PM2024-03-28T15:29:31+00:00
October 4, 2023 7:12 AM2024-03-28T15:29:31+00:00
NaN

No.31 formula-5:复选框格式(Formula Format CheckBox)

No.31 Demo A

NameC1F1F2No.31 Demo B

No.31 Demo B

NameNo.31 Demo ARollupF1
true

No.32 formula-6:If 函数(Formula If)

No.32 Demo A

NameN1F1N2F2N3F3
177
Yes
188
N1
188
N1
188
No
177
N2
188
N2
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
-1281
🚧已过1281天
-30751
-1281
🚧已过1281天
🚧已过1281天
October 4, 2023 7:12 AM2024-03-28T15:29:31+00:00
October 1, 2020
-1098
🚧已过1098天
-26359
-1098
🚧已过1098天
🚧已过1098天
October 4, 2023 7:12 AM2024-03-28T15:29:31+00:00
January 1, 2020
-1372
🚧已过1372天
-32935
-1372
🚧已过1372天
🚧已过1372天
October 4, 2023 7:12 AM2024-03-28T15:29:31+00:00
March 13, 2020
-1300
🚧已过1300天
-31207
-1300
🚧已过1300天
🚧已过1300天
October 4, 2023 7:12 AM2024-03-28T15:29:31+00:00
NaN
🚧已过天
NaN
NaN
🚧已过天
🚧已过天
October 4, 2023 7:12 AM2024-03-28T15:29:31+00:00
March 12, 2020
-1301
🚧已过1301天
-31231
-1301
🚧已过1301天
🚧已过1301天
October 4, 2023 7:12 AM2024-03-28T15:29:31+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
⭐️️
■■■ 30%
0.3
0.12903225806451613
3.748633879781421
NaN
%
■■■ 30%
🌙
■ 12.90%
0.3
0.12903225806451613
3.748633879781421
NaN
%
■ 12.90%
🌞️
■■■■■■■■■■ 374.8%
0.3
0.12903225806451613
3.748633879781421
NaN
%
■■■■■■■■■■ 374.8%
☁️️
January 1, 2000 → December 31, 2099
■■ 23.75%
0.3
0.12903225806451613
3.748633879781421
0.23757803088380244
■■ 23.75%
■■ 23.75%
☁️️
%
0.3
0.12903225806451613
3.748633879781421
NaN
%
%
☁️️
March 20, 2020 3:00 PM (GMT+8) → March 20, 2020 5:00 PM (GMT+8)
⛔️️ 已过期
0.3
0.12903225806451613
3.748633879781421
15512.1
⛔️️ 已过期
⛔️️ 已过期

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
-1294
March 20, 2020
-1293
March 21, 2020
-1292
March 22, 2020
-1291
March 23, 2020
-1290
March 24, 2020
-1289
March 25, 2020
-1288
March 26, 2020
-1287
March 27, 2020
-1286
March 28, 2020
-1285
March 29, 2020
-1284
March 30, 2020
-1283
March 31, 2020
-1282
April 1, 2020
-1281
April 2, 2020
-1280
April 3, 2020
-1279
April 4, 2020
-1278

No.36 Demo B: Basic Archive

NameArchivedLast Edited
Apr 28, 2020 2:41 PM
Apr 28, 2020 2:41 PM
Apr 28, 2020 2:41 PM

No.36 Demo C: Daily Checklist

NameABCDateStatus
March 2, 2020
🔒️ 已过期/Expired
March 12, 2020
🔒️ 已过期/Expired
March 27, 2020
🔒️ 已过期/Expired
March 28, 2020
🔒️ 已过期/Expired
⏺ TBD
⏺ TBD