The Beauty Of The Formula

Notion has a pretty intuitive formula system and it's relational database foundation would suffer without it. A program built for scheduling, communicating, and storing needs automation. Why? The intention for Notion users is to keep tons and tons of information stored into databases. It's a space that invites hoarding, collecting and organizing hundreds of data entries. The only way to manage, recall and relate so much is to use formulas.

If a user, for instance, wants to return the weekday of every date property in a database with 200+ entries, they'd rather not do it manually. Instead, they may use this short formula: formatDate(prop("Date"), "dddd").

Another use for formulas that's a bit more fun is to add holidays to a calendar. I found this list of common holidays from Wikipedia to put inside my example:

Calendar With Holidays

Formula: if(contains(format(prop("Date")), "Dec 25"), "🎄Christmas Day!", if(contains(format(prop("Date")), "Jul 4"), "🔔Independence Day!", if(contains(format(prop("Date")), "Oct 31"), "🎃Halloween", if(contains(format(prop("Date")), "Feb 14"), "💘Valentine's Day!", if(contains(format(prop("Date")), "Mar 17"), "🍀St. Patrick's Day!", if(contains(format(prop("Date")), "Dec 31"), "⭐️New Year's Eve!", ""))))))

Want a 2020/2021 pre-filled database to insert a holiday formula into?

I created one for purchase. Dates range from Aug 17, 2020 → December 31, 2021

Pre-Filled Notion Calendar Database 2020/2021

Mood This Week

Untitled

Published This Week

https://youtu.be/gtHeEIHRbG4

https://youtu.be/4m4_q4UEZDE

Notion Formula: Difference Between Two Values In The Same Column - Red Gregory

Notion Design: Interesting KaTeX Symbols - Red Gregory

Notion For Freelancers: Track Paid Working Hours - Red Gregory