How To Use Notion Formulas | Ep. 1: Project Management (Days Remaining To Deadline)

View Example In Notion: https://www.notion.so/redgregory/Noti...

🔜 In this first video in a series of Notion formula tutorials, we'll create a bare-bones project management space. Included is a "Tasks" and "Projects" database of which are related to one another. As well, a percentage of completed checkboxes, a formula to return if a deadline is in the past, present, or future, how many days remaining until deadline, and an action property to return a command (ex. Priority, Urgent, and Archive).

Timestamps:

0:00 - Intro
0:56 - Table Setup
1:59 - unaryPlus/Checkbox % (round, ceil, floor)
7:08 - Connect Tasks to Projects
7:57 - Days Remaining (dateBetween, Sign, Now)
13:21 - Past, Present, Future pt.1
14:51 - If Statements
18:08 - Past, Present, Future pt.2 (abs, format)
21:25 - Priority Formula (contains, toNumber)
27:04 - Filter Archive/gifs
29:45 - Outro

Twitter:   / redgregory1  
More about Notion: https://www.redgregory.com/