Build Better Formulas with Notion Formulas 2.0
Today, Notion introduced the biggest update of the year – Formulas 2.0. The Formulas 1.0 language and editor has been completely overhauled, making Notion formulas...
Useful Notion Features You May Not Know About Yet
I’ve compiled together a list of the most useful Notion features that I believe everyone should know about, plus some of the most useful Notion...
Decision Tree Matrix to Filter by Variable Criteria
Here is how to build a decision tree matrix to dynamically filter by variable criteria in Notion. When challenged to find a way to set...
Get First, Middle & Last Names From a Full Name String
I recently took on a challenge for myself to come up with a reliable method for extracting the first, middle, and last names from a...
Date is Last Week, This Week or Next Week (Accurate Formulas)
If you’ve been knocking around Notion for a while you’ve probably had occasion to dynamically check if an entry date falls within the current week....
Calculate Business Days Between Two Variable Dates
In problem solving a scenario I found the need to calculate the number of business days between two variable dates. This turns out to be...
Auto-Increment Table Row IDs
Update 05/19/2023 – I am happy to report that this hack is now obsolete! Read the reason why here In the absence of a native...
Convert Text Date to Actual (Usable) Date
If you’ve ever had a date written within a text-based database property, you’ve probably experienced frustration that it is not actually recognized as a date...
Multi-Select Progress (Count Number of Options Selected)
Do you have a lot of tasks or habits to complete, but don’t want to create checkbox properties for each of them? Here’s an alternative...
Project Tasks Progress Display
Here’s a fun, new way to visualize the status of tasks for a project! We use formulas to calculate how many tasks are “incomplete” and...
Calculate the Next Occurrence of a Date (After Today)
If you have an event, task, bill or subscription that happens on a weekly, monthly or yearly recurring cycle, here is a formula that will...
Timeline Progress Visual Display
Here is a nice visual way to display progress within a timeline using a formula. Our formula is going to require a few different properties...