Formulas
🤖

Formulas

Kitchen Sink Formulas

NameTextNumberSelectMulti-selectDatePersonFilesCheckboxURLPhoneCreated byCreated timeLast edited byLast edited timeDate formulaBoolean formulaDate formula 2Nested if formulaMulti-select length formula
🏢
New York
test
42
foo
foobarnala
Jul 23, 2020
Travis Fischer
Aug 21, 2020 4:52 AM
Aug 21, 2020 4:52 AM
Test: Thu Jul 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
It's False
13
London
-32.48
bar
nalagit
Jul 31, 2010 → Jul 31, 2020
Steve Peak
Aug 21, 2020 4:52 AM
Aug 21, 2020 4:52 AM
Test: Sat Jul 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time) → Fri Jul 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)
It's False
9
Shanghai
looooooooooooooooooooooooooooooooooooooooooooooooooooooooooong looooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooong loooooooooooooooooooooooooooooong
1000099
bar
foogitbazabcghijklmnostu
Jul 22, 3000
Aug 21, 2020 4:52 AM
Aug 21, 2020 4:52 AM
Test: Tue Jul 22 3000 00:00:00 GMT+0000 (Coordinated Universal Time)
It's False
32
empty
Aug 21, 2020 4:52 AM
Aug 21, 2020 4:52 AM
Test:
It's False
0

Date Formulas

NameWeekdayMidnightMisc
Tuesday
Jul 20, 2021 12:00 AM (UTC)
No
Tuesday
Jul 20, 2021 12:00 AM (UTC)
No
Tuesday
Jul 20, 2021 12:00 AM (UTC)
No

External Resources

Notion Formulas
  • Excellent test suite