Notion formulas | A beginner's guide
Sign up for Notion 📗: https://go.janoschsworkspace.com/notion
In today's video, I'll give you a brief introduction to Notion formulas and show you how you can use them in your Notion workspace! Have fun :)
📷MENTIONED IN THE VIDEO
Here's the formula for the progress bar:
if(prop("Status") == "Potential client", "✔⚪⚪⚪⚪ 20%", if(prop("Status") == "First contact", "✔✔⚪⚪⚪ 40%", if(prop("Status") == "Offer sent", "✔✔✔⚪⚪ 60%", if(prop("Status") == "Negotiations", "✔✔✔✔⚪ 80%", if(prop("Status") == "Contract signed", "✔✔✔✔✔ Project completed!", "0")))))
To use it, create different statuses and change them in the text (e.g. change "Potential client" to a status of your liking).
⏰TIMESTAMPS
00:00 - Introduction
00:27 - What are Notion formulas made of?
01:25 - Operators
02:37 - Use case: Grade calculator
04:31 - if-statements
05:38 - Functions
07:11 - Date functions
08:09 - Use case: Check for overdue events
09:43 - Use case: Progress bar
11:40 - Outro
🔗THE COMPLETE NOTION 101 COURSE
Check out the complete Notion 101 course on Skillshare: https://go.janoschsworkspace.com/noti...
Check out the complete Notion 101 course on Udemy: https://go.janoschsworkspace.com/noti...
🎵MUSIC
Music by ninjoi. - Nishi - https://thmatc.co/?l=4556913A
Music by ninjoi. - Acceptance - https://thmatc.co/?l=64B2C335
Music by ninjoi. - Natsu - https://thmatc.co/?l=FB212DDE
Music by ninjoi. - Sakana - https://thmatc.co/?l=956546DB
Music by Clueless Kit - lemon - https://thmatc.co/?l=DEB4770B