All TemplatesTwitterBlogYouTubeBlog Starter
All TemplatesTwitterBlogYouTubeBlog Starter
80 Notion Formulas To Copy

80 Notion Formulas To Copy

image

Formula References

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

View Progress Bar Designs

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