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 →

💡

3️⃣ Notion 中的 formula 列表中文说明和个人使用情况 →

💡

4️⃣ 原始教程/Tutorial list →

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
298
298
876
366
February 11, 2020
May 9, 2020
40
40
835
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
1.2676506002282365e-70
3.31640625
%
100
177
1
3.31640625
100%
177
NaN
3.31640625
%

No.30 formula-4:日期格式(Formula Format Date)

No.30 Demo A

NameDate1F1F2F3Date2F22
January 1, 2020 → January 1, 2021
January 1, 2020 12:00 AM2022-05-28T06:54:21+00:00 → January 1, 2021 12:00 AM2022-05-28T06:54:21+00:00
February 25, 2020 4:00 PM2022-05-28T06:54:21+00:00
May 26, 2022 4:06 AM2022-05-28T06:54:21+00:00
NaN
February 26, 2020
February 26, 2020 12:00 AM2022-05-28T06:54:21+00:00
February 25, 2020 4:00 PM2022-05-28T06:54:21+00:00
May 26, 2022 4:06 AM2022-05-28T06:54:21+00:00
February 29, 2020
1582934400000
May 26, 2022 4:06 AM2022-05-28T06:54:21+00:00
February 25, 2020 4:00 PM2022-05-28T06:54:21+00:00
May 26, 2022 4:06 AM2022-05-28T06:54:21+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
-785
🚧已过785天
-18844
0
🔔即将过期
🔔即将过期
May 26, 2022 4:06 AM2022-05-28T06:54:21+00:00
国庆节
October 1, 2020
-602
🚧已过602天
-14452
8
⌛️️还剩8天
⌛️️还剩8天
May 26, 2022 4:06 AM2022-05-28T06:54:21+00:00
元旦
January 1, 2020
-876
🚧已过876天
-21028
16
⌛️️还剩16天
⌛️️还剩16天
May 26, 2022 4:06 AM2022-05-28T06:54:21+00:00
明天/tomorrow
March 13, 2020
-804
🚧已过804天
-19300
8
⌛️️还剩8天
⌛️️还剩8天
May 26, 2022 4:06 AM2022-05-28T06:54:21+00:00
无日期/empty
NaN
🚧已过天
NaN
NaN
🚧已过天
🚧已过天
May 26, 2022 4:06 AM2022-05-28T06:54:21+00:00
今天/today
March 12, 2020
-805
🚧已过805天
-19324
8
⌛️️还剩8天
⌛️️还剩8天
May 26, 2022 4:06 AM2022-05-28T06:54:21+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
⭐️️
%
0
0.004285103126445424
298
NaN
%
%
Month
🌙
0.428%
0
0.004285103126445424
298
NaN
%
0.428%
Year
🌞️
■■■■■■■■■■ 29800%
0
0.004285103126445424
298
NaN
%
■■■■■■■■■■ 29800%
Customize(21st century)
☁️️
January 1, 2000 → December 31, 2099
%
0
0.004285103126445424
298
0
%
%
No Date
☁️️
%
0
0.004285103126445424
298
NaN
%
%
2H
☁️️
March 20, 2020 3:00 PM (GMT+8) → March 20, 2020 5:00 PM (GMT+8)
%
0
0.004285103126445424
298
NaN
%
%

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
16
@March 20, 2020
March 20, 2020
0
@March 21, 2020
March 21, 2020
8
@March 22, 2020
March 22, 2020
8
@March 23, 2020
March 23, 2020
8
@March 24, 2020
March 24, 2020
0
@March 25, 2020
March 25, 2020
0
@March 26, 2020
March 26, 2020
8
@March 27, 2020
March 27, 2020
16
@March 28, 2020
March 28, 2020
16
@March 29, 2020
March 29, 2020
8
@March 30, 2020
March 30, 2020
16
@March 31, 2020
March 31, 2020
8
@April 1, 2020
April 1, 2020
0
@April 2, 2020
April 2, 2020
16
@April 3, 2020
April 3, 2020
0
@April 4, 2020
April 4, 2020
16

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
⏺ TBD
2
March 12, 2020
⏺ TBD
3
March 27, 2020
⏺ TBD
4
March 28, 2020
⏺ TBD
5
⏺ TBD
6
⏺ TBD