80 Notion Formulas To Copy

80 Notion Formulas To Copy

image

Dates

Date Relating To Now

Date Is Today
Date Is Tomorrow
Date Is Before Or On Today
Date Is Before Today
Date Is After Today
Date Is After Or On Today
Date Is In Current Month
Date Is In Current Quarter
Date Lands In This Week (week starts on monday)
Date Lands In This Week (week starts on sunday)
Today Falls Within Date-Range

Date Calculations

*Replace prop("Date") w/ now() to return formulas relating to today

Find Month And Return First Day Of Month
Find Month And Return Last Day Of Month
Week # Of The Month (week starts on monday)
Week # Of The Month (week starts on sunday)
Find Age From Birthday
Total Days In Date's Month
Find Hours And Minutes Between Date-Range
Find Hours And Minutes Between Two Dates

Format Dates

Format Weekday
Format Month
Format Quarter
Format Time Of Day (AM/PM)
Format Time Of Day (ie. morning)
Format Date (M/D/YYYY)
Format Date and Time (MMM D, YYYY h:mm A )
Format Full Time (h:mm A)
Format Timezone
Format Day # Of The Year

Date Use-Cases

Super Minimal Deadline
Find Season From Date (Northern Hemishpere)
Find Season From Date (Southern Hemishpere)

Text

Format Text

Convert Lowercase To Uppercase
Convert Uppercase To Lowercase

Extract Text

Extract First Name (john smith)
Extract Last Name (john smith)
Extract All Numbers From Text
Extract All Non-Numbers From Text
Extract All Characters After A Special Character
Extract All Characters Before A Special Character
Remove All Special Characters
Extract All Text Between Two Characters (example: text between parenthesis)
Find Number Of Tags/Relations

Extract From URL

Extract Name Of Website
Extract Twitter Handle (@johnsmith)

Numbers

Round Numbers

Round To Nearest .01
Round To Nearest .1
Round To Nearest .5
Round To Nearest 1
Round To Nearest 5
Round To Nearest 10
Round To Nearest 25

Convert To Number

If Checkbox Is True, Return 1 ... If False, Return 0
Convert Text To Number

Progress Bars

Progress Bar Designs

Diamond Progress Bar
Block Progress Bar
Bold Bars Progress Bar
Thin Bars Progress Bar
Lines Progress Bar
Plain Circle Progress Bar
Dotted Progress Bar
Bubbles Progress Bar
Levels Progress Bar

Slider Designs

Cube Slider Bar
Classic Slider Bar
Loading Slider Bar
Thin Slider Bar
Raised Disk Slider Bar
Floating Slider Bar
8-Bit Slider Bar
Lite Floating Slider Bar

Unique Progress Bars

Weekly Progress Indicator From Date (Su-Sa)
Weekly Progress Indicator From Date (Mo-Su)
Double-Progress Bar
Progress Of Current Year
Progress Of Current Week
Progress Of Current Day

Other

Files & Media

Find File Type (One File)

Empty Cell

If Another Cell Is Empty, Return Alert
If Another Cell Is Not Empty, Return Alert