Notion Formulas: Everything You Ever Need To Know II Complete Tutorial

Опубликовано: 18 Октябрь 2024
на канале: Matthias Frank
8,363
193

Learn everything about Notion Formulas including Notion tips and tricks in this Notion Tutorial for Beginners.

New Notion Formulas:    • NOTION FORMULAS 2.0: What You Need To...  

Free printable Notion Shortcuts cheatsheet: https://matthiasfrank.de/shortcuts/

Follow the Tutorial: https://matthiasfrank.de/notion-tutor...

Part 5 of our Notion Tutorial is all about Notion Formulas. Formulas are probably one of the latest features beginners explore when learning Notion. They can seem intimidating and complex. But once you understand a few basic principles, you'll be able to use Notion Formulas to elevate your Notion workspace to new heights.

This video will teach you the basics for Notion Formulas plus the four main categories of Notion Formulas:

- Simple Calculations
- Date Manipulation
- String Manipulation
- Logic

You'll learn the most important formulas for each category plus sample use cases to immediately start implementing them in your Notion Workspace

_______________

How to learn Notion Full Tutorial - Previous Videos:

Setting Up Your Workspace:    • How to Use Notion Full Tutorial Part ...  

How does Notion actually work?    • How to Use Notion Tutorial Part 2: Or...  

Pages in Notion: Everything you ever need to know    • Everything you need to know about Not...  

Notion Databases: Everything you ever need to know
   • Notion Databases: Everything you ever...  

_______________

More cool use cases for formulas in Notion?

How to get a Week View in Notion:    • SOLVED: Week View in Notion (with fre...  

How to get statistics in Notion:    • Create beautiful Statistics in Notion...  

_______________

More Resources:

Regex Builder: https://www.autoregex.xyz/

Formula Overview by Thomas Frank: https://learn.thomasjfrank.com/notion...

_______________


Chapters:
00:00 Intro
00:33 Notion Formula Basics
01:38 How to add a formula to Notion
03:05 How to call a property in a Notion Formula
04:50 Can you call a different row in a Notion Formula?
05:30 What are the data types for Notion Formulas?
05:40 What is a boolean?
06:50 What is a string?
07:10 Difference between strings and numbers
07:48 Date Properties in Notion Formulas
10:57 Calculations in Notion Formulas
11:40 How to calculate Percent in Notion
12:18 How to round numbers in Notion
16:00 How to compare numbers in Notion
16:30 Date Manipulation
17:30 How to get the current time with a Notion Formula
17:58 How to get a timestamp in Notion
19:30 How to get a date from a timestamp in Notion
20:33 How to check for overdue date in Notion
24:00 How to add days to date with a Notion Formula
28:50 How to format dates with Notion Formulas
31:53 DateBetween Notion Formula
33:06 How to show only dates for the next three days
37:08 String Manipulation
38:10 How to turn a number into a string
38:53 How to turn a string into a number
40:00 How to combine strings in Notion
44:00 How to get length of string in Notion
45:00 How to use replace and replaceAll Notion Formulas
46:08 Regex in Notion
48:01 How to remove all letters with Notion Formula
49:10 How to remove all numbers with Notion Formula
51:17 How to use slice in Notion Formula
52:25 How to create a progress bar with Notion Formula
55:06 Logic in Notion Formulas
56:26 How to use if statements in Notion
01:01:14 How to use and operator in Notion Formula
01:03:00 How to nest conditions in Notion
01:06:30 How to use or operator in Notion Formula
01:07:54 How to check for empty properties in Notion
01:08:20 Outro

_______________

Notion and the Notion logo are trademarks of Notion Labs, Inc., and are used here with permission.