177 Formula demo
⚗

177 Formula demo

Tags
FormulaDemo
Date
February 19, 2020
Related Tutorial
No.27 formula-1：公式组成和特性（Formula Structure Characteristic）No.27 formula-1：公式组成和特性（Formula Structure Characteristic）No.28 formula-2：字符串格式（Formula Format String）No.28 formula-2：字符串格式（Formula Format String）No.29 formula-3: 数字格式（Formula Format Number）No.29 formula-3: 数字格式（Formula Format Number）No.30 formula-4：日期格式（Formula Format Date）No.30 formula-4：日期格式（Formula Format Date）No.31 formula-5：复选框格式（Formula Format CheckBox）No.31 formula-5：复选框格式（Formula Format CheckBox）No.32 formula-6：If 函数（Formula If）No.32 formula-6：If 函数（Formula If）No.33 formula-7：常用推荐：倒计时（Formula Recommend Countdown）No.33 formula-7：常用推荐：倒计时（Formula Recommend Countdown）No.34 formula-8：常用推荐：关联进度条（Formula Recommend Progress）No.34 formula-8：常用推荐：关联进度条（Formula Recommend Progress）No.35 formula-9：常用推荐：多进度条（Formula Recommend Progress）No.35 formula-9：常用推荐：多进度条（Formula Recommend Progress）No.36 formula-10：日期过滤 & 归档 （Formula Date Filter Archive）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(Deprecated)_Notion tutorial lite(Deprecated)_

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

No.27 demo A

Name
X
Y
Z
All in 1
1
2
3
7

No.27 demo B: Time progress

Name
开始/Start
End
时间进度/Progress
All in 1
已过天数/Days
总天数/Total
January 1, 2020
January 1, 2021
4.877049180327869
4.877049180327869
1785
366
February 11, 2020
May 9, 2020
19.818181818181817
19.818181818181817
1744
88

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

No.28 demo A

Name

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

No.29 Demo A

Name
N1
F1
F2
F3
N2
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 formula-4：日期格式（Formula Format Date）

No.30 Demo A

Name
Date1
F1
F2
F3
Date2
F22
January 1, 2020 → January 1, 2021
January 1, 2020 12:00 PM2025-04-23T04:39:52+00:00 → January 1, 2021 12:00 PM2025-04-23T04:39:52+00:00
February 25, 2020 4:00 AM2025-04-23T04:39:52+00:00
November 20, 2024 2:43 AM2025-04-23T04:39:52+00:00
NaN
February 26, 2020
February 26, 2020 12:00 PM2025-04-23T04:39:52+00:00
February 25, 2020 4:00 AM2025-04-23T04:39:52+00:00
November 20, 2024 2:43 AM2025-04-23T04:39:52+00:00
February 29, 2020
1582934400000
November 20, 2024 2:43 AM2025-04-23T04:39:52+00:00
February 25, 2020 4:00 AM2025-04-23T04:39:52+00:00
November 20, 2024 2:43 AM2025-04-23T04:39:52+00:00
NaN

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

No.31 Demo A

Name
C1
F1
F2
No.31 Demo B
31_B1

No.31 Demo B

Name
No.31 Demo A
Rollup
F1
31_A1

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

No.32 Demo A

Name
N1
F1
N2
F2
N3
F3
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 Countdown Demo A

Name
D
F1
F2
F3
F4
F5
F6
Now
April 1, 2020
-1694

🚧已过1694天

-40670
-1694

🚧已过1694天

🚧已过1694天

November 20, 2024 2:43 AM2025-04-23T04:39:52+00:00
October 1, 2020
-1511

🚧已过1511天

-36278
-1511

🚧已过1511天

🚧已过1511天

November 20, 2024 2:43 AM2025-04-23T04:39:52+00:00
January 1, 2020
-1785

🚧已过1785天

-42854
-1785

🚧已过1785天

🚧已过1785天

November 20, 2024 2:43 AM2025-04-23T04:39:52+00:00
March 13, 2020
-1713

🚧已过1713天

-41126
-1713

🚧已过1713天

🚧已过1713天

November 20, 2024 2:43 AM2025-04-23T04:39:52+00:00
NaN

🚧已过天

NaN
NaN

🚧已过天

🚧已过天

November 20, 2024 2:43 AM2025-04-23T04:39:52+00:00
March 12, 2020
-1714

🚧已过1714天

-41150
-1714

🚧已过1714天

🚧已过1714天

November 20, 2024 2:43 AM2025-04-23T04:39:52+00:00

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

视频中的原始页面/Original page in video →

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

视频中的原始页面/Original page in video →

No.35 Progress Demo A

Name
Type
Date
F7
F1
F2
F3
F4
F5
F6
⭐️️

■■■■■■ 61.31%

0.6131944444444445
0.6451612903225806
4.877049180327869
NaN

%

■■■■■■ 61.31%

🌙

■■■■■■ 64.51%

0.6131944444444445
0.6451612903225806
4.877049180327869
NaN

%

■■■■■■ 64.51%

🌞️

■■■■■■■■■■ 487.7%

0.6131944444444445
0.6451612903225806
4.877049180327869
NaN

%

■■■■■■■■■■ 487.7%

☁️️
January 1, 2000 → December 31, 2099

■■ 24.88%

0.6131944444444445
0.6451612903225806
4.877049180327869
0.24889423925212037

■■ 24.88%

■■ 24.88%

☁️️

%

0.6131944444444445
0.6451612903225806
4.877049180327869
NaN

%

%

☁️️
March 20, 2020 3:00 PM (GMT+8) → March 20, 2020 5:00 PM (GMT+8)

⛔️️ 已过期

0.6131944444444445
0.6451612903225806
4.877049180327869
20471.858333333334

⛔️️ 已过期

⛔️️ 已过期

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

视频中的原始页面/Original page in video →

No.36 Demo A: days left

Name
Date
days left
March 19, 2020
-1707
March 20, 2020
-1706
March 21, 2020
-1705
March 22, 2020
-1704
March 23, 2020
-1703
March 24, 2020
-1702
March 25, 2020
-1701
March 26, 2020
-1700
March 27, 2020
-1699
March 28, 2020
-1698
March 29, 2020
-1697
March 30, 2020
-1696
March 31, 2020
-1695
April 1, 2020
-1694
April 2, 2020
-1693
April 3, 2020
-1692
April 4, 2020
-1691

No.36 Demo B: Basic Archive

Name
Archived
Last 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

Name
A
B
C
Date
Status
March 2, 2020

🔒️ 已过期/Expired

March 12, 2020

🔒️ 已过期/Expired

March 27, 2020

🔒️ 已过期/Expired

March 28, 2020

🔒️ 已过期/Expired

⏺ TBD

⏺ TBD