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....
Import Your Goodreads Library to Notion + Add Book Covers (No API, 2-Click Solution)
Recently, I migrated my Goodreads content into Notion. With that came the need to add book covers, as the Goodreads export doesn’t include hyperlinks for...
How I Use Notion for Novel Writing
Once upon a time… I created a minimalist, distraction-free Notion template for writers that focused on just the words. I’ve used it extensively, but it’s...
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...
Force Link Between Two Database Items Automatically
Want to automatically link a new database item to an item in another table? Accomplish this quickly and easily using Notion’s new “Group” feature....
Shoulder Surf Sessions #3: Using Template Buttons to Create Dynamic Layouts
Case study: Creating a Pinterest-style pin board. Third in the Shoulder Surf Sessions video series we explore how to create dynamic layouts using Template...
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...