As a contract/freelance worker, tracking time worked is essential. As well, calculating clock-in and clock-out times for life tracking purposes can be useful. This formula will allow you to grab the total hours and minutes elapsed from a date range.
Blog about Notion.so
If you’re looking for the ability to allocate tasks into a timetable, but have a hard time figuring out how much time each task should be alloted, I created this smart task planner to do that work for you. All you’ll need to know is how many hours you have available to work, and task difficulty between 1-10.
I've made a couple attempts thus far at family trees in Notion. This approach is proving to be the easiest to use, so I wanted to share it with you. Included are timeline, family, and atlas databases connected via relations. It also has a formula to help me determine the age a member died or what age they currently are.
If you’re looking for the solution to discrepancies between two or more values in Notion, use the functions abs, min, max, and subtract. And remember, Notion can only calculate values in a table’s row. For column calculations, a built in column calculation button is provided, however, is more limited than row calculations.
I like to use Notion for my history notes, and I like to have fun with my Who’s Who database of historical figures. After creating this zodiac formula, I set out to create a property that can return the age of a person that is still living. As well, I wanted to know what generation they belong to.
If you’re looking to create a Notion workspace with minimal friction, using the in-line template is a must. Especially so, using a template to add new entries to a remote database without having to navigate to the table. Place a button like this in your dashboard for quick access to daily databases like the habit tracker below.
In addition to this distribution table I made to show me based on today’s day of the week what content I should publish, I set out to solve one more problem: show me what tasks I need to get ready to publish tomorrow. In short, add one day to today and return any tasks that contain tomorrow. Here’s the formula breakdown.
During today's noodling inside Notion I set out to create a "content distribution" table that displays certain tasks assigned to a particular weekday. For instance, my table will show me content that must be distributed on Sundays only when today is Sunday. As well, I figure out how I can integrate "every other week" and "monthly" options.
I like to discover to what bounds Notion can offer in regards to calculations. It’s certainly not a spreadsheet and has its limitations (especially for finance), but it is capable of linear calculations (by row). Here is how you can find the compound annual growth of an investment using this short formula. Used in this tutorial are the functions Ro
I've been neglecting my webclipper for quite a while due to my lack of what to save. Since I've been on Twitter more than I probably should, I figured I'd create a database in Notion that saves my favorite tweets. In addition to saving tweets, I created a formula property that extracts a profile's handle and another property to makeshift tag automation for webclipper.
Following my Tag Wall tutorial, of which I find is hard to explain in words, I made this little video to talk through the process slowly. As well, I share some basic Notion pages that fit nicely in a minimal dashboard. Used primarily in this tutorial is the relation property. If you are unaware of this property or don’t understand how it works, this is a good place to start.
Database, Relations, Program Functions
Notion has teased the upcoming “timeline” feature for quite a while with no discernable release date, however, if you’re looking for the ability to build a timeline that spans a vast amount of time (ie. years or centuries), this is what I’ve been using for my history notes. As well, I will show you how to connect notes to this timeline with relation properties.
Database, Dashboards, Planning, Relations