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 → 177177
💡
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-07-27T03:28:17+00:00 → January 1, 2021 12:00 AM2024-07-27T03:28:17+00:00
February 25, 2020 4:00 PM2024-07-27T03:28:17+00:00
October 4, 2023 7:12 AM2024-07-27T03:28:17+00:00
NaN
February 26, 2020
February 26, 2020 12:00 AM2024-07-27T03:28:17+00:00
February 25, 2020 4:00 PM2024-07-27T03:28:17+00:00
October 4, 2023 7:12 AM2024-07-27T03:28:17+00:00
February 29, 2020
1582934400000
October 4, 2023 7:12 AM2024-07-27T03:28:17+00:00
February 25, 2020 4:00 PM2024-07-27T03:28:17+00:00
October 4, 2023 7:12 AM2024-07-27T03:28:17+00:00
NaN

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

No.31 Demo A

NameC1F1F2No.31 Demo B
31_B1

No.31 Demo B

NameNo.31 Demo ARollupF1
31_A1

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-07-27T03:28:17+00:00
October 1, 2020
-1098

🚧已过1098天

-26359
-1098

🚧已过1098天

🚧已过1098天

October 4, 2023 7:12 AM2024-07-27T03:28:17+00:00
January 1, 2020
-1372

🚧已过1372天

-32935
-1372

🚧已过1372天

🚧已过1372天

October 4, 2023 7:12 AM2024-07-27T03:28:17+00:00
March 13, 2020
-1300

🚧已过1300天

-31207
-1300

🚧已过1300天

🚧已过1300天

October 4, 2023 7:12 AM2024-07-27T03:28:17+00:00
NaN

🚧已过天

NaN
NaN

🚧已过天

🚧已过天

October 4, 2023 7:12 AM2024-07-27T03:28:17+00:00
March 12, 2020
-1301

🚧已过1301天

-31231
-1301

🚧已过1301天

🚧已过1301天

October 4, 2023 7:12 AM2024-07-27T03:28:17+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