Formula

Relations, Database, Planning

Free Notion Template: Airline Ticket Organizer for Travel

For those looking for an easy way to manage their travel information, this Notion template for airline tickets can provide a great solution. This template is designed to help users keep track of airline tickets and associated information. It includes sections for collecting and organizing information like flight number, departure and arrival times, airline, layovers, and more.

Database

Free Notion Template: Address List with Map Generator

This address list Notion template is a great tool for organizing places you’re going, places you’ve been, or places to catalog. In this post, we'll look at how the address list can be used to keep track of address information for individuals, businesses, or other places. The template includes properties that describe an address’s name of place, building status, and country, in addition to generating links to Google and Apple maps.

Program Functions

11 Ways to Generate Clickable Links with Notion Formulas

Notion formulas can now be used to create clickable links that make constructing and navigating URL links a breeze. Creating clickable links in Notion formulas only requires inputting the correct code that results in a url syntax (https://www.website.com/…). Below are instructions on how to generate clickable links in Notion formulas for maps, social media searches, Twitter profiles, Wikipedia, Goodreads, and Amazon.

Planning, Database, Design

Populate A Weekly Spread From a Notion Calendar

This is a weekly spread between Monday and Sunday that will auto-populate from a Notion calendar. All days are spread into two rows of four columns. For those who like the presentation of a non-database weekly spread but also like the convenience of a database manager, this is the best of both worlds, and it takes a few minutes to setup. There is also the option to duplicate the Notion template below the tutorial.

Database

Push Overdue Tasks To Today In Notion

If a task is overdue, push the due date in Notion to today, and show the new due date in a calendar. If the task is not overdue or complete, show the original due date. We also explore how to see this new date formula in a calendar view. Calendars can only see one date at a time so it is important to join all dates you want to see into one Notion formula. Here is how it works.

Database

Notion Formulas: contains() vs test() Functions

The contains() and test() function in Notion conduct similar tests on database properties. Both functions allow the user to check for strings in another property. For example, to check for the string “Hello” in a string property named “Name”, call contains(prop("Name"), "Hello") or test(prop("Name"), "Hello"). Both codes will return a true boolean. What exactly is the difference between these two functions then?

Relations, Dashboards

How To Use Notion Rollups To Build A Habit Tracker

With the addition of Notion’s new progress bar feature, habit trackers can now include analytical properties with rollups. Notion allows the rollup property to produce progress bars, and this is how I would use the new functionality to create an analytical habit tracker to track both completion rates of individual habits and determine what weekdays produce the best results.

Relations

How I Compare Data Between Notion Pages

May 10th, 2022 began my 30-day content challenge where I publish one piece of content every day for a month. I’m one week into the challenge and I want to share the homepage I built in Notion to track my progress daily and weekly. Have you ever wondered how to effectively compare data between database rows in Notion? This use-case may be helpful. Here is how it works.

How To Build Colorful Notion Progress Bars

Update your Notion progress bars with these colorful designs. All you’ll need is a percentage to work with and the following formulas. Included are two designs, one for a slider progress bar, and another for a Notion progress bar that changes colors as the percentage increases. Here is how they work.

Database

6 Valuable Notion Formulas For The Web Clipper

Do you use a web clipper with Notion to bookmark URLs? These formulas can enhance your Notion web clipper database to help organize and group saves. For example, you can extract the Twitter profile from a saved tweet. Next, group all tweets by Twitter user. Copy and paste the codes below into a formula property to see how they can work for you.

9 Useful Date And Time Notion Formulas

There are a great number of ways to manipulate dates in Notion with the formula property. For dates that include a time, traditional formulas may not work in the same way. The nine following formulas come straight from my formula archive, and they’ve helped me manage date/time properties in my Notion databases.

Database, Planning

Track Productivity In Notion With This Simple Timesheet

Here is a simple timesheet database template in Notion that requires little to no system building and can help you get right to work. This is a planner and timesheet for your working sessions. For example, you can track total hours worked for projects your working on, describe how well each session went, and analyze most and least productive weeks and months of the year. Here’s how it works.

Dashboards, Relations

A Clean Notion Dashboard To View Subtasks (Free Template)

There are many options to view your tasks in Notion, including a table, kanban, and gantt chart. In this clean dashboard template, I include a variety of windows to access stacked tasks in the program. Stacked tasks are a collection of to-dos that can be simplified into small manageable objectives. The layers in this stackable workspace are Area, Parent Task/Project, Subtask, and Timetable.

Dashboards, Templates

How I Made My Yearly Content Review In Notion

My annual review is the result of wanting to create a page that displays all analytics from online projects in the last twelve months. There are two core Notion databases here. One is for a monthly review where all data is gathered, and the other is for three main areas to analyze: my blog, Twitter, and YouTube. Here is how I used the data from each monthly review to create a 2021 review.