Notion Formulas: Episode 1

unaryPlus 1:59 (unaryMinus, round, ceil, floor)

unaryPlus(42)

unaryMinus(42)

unaryPlus(true)

unaryPlus(false)

unaryPlus(prop("Discuss"))

(unaryPlus(prop("Discuss")) + unaryPlus(prop("Procedures")) + unaryPlus(prop("Review")) + unaryPlus(prop("Final"))) / 4

round(100 * (unaryPlus(prop("Discuss")) + unaryPlus(prop("Procedures")) + unaryPlus(prop("Review")) + unaryPlus(prop("Final"))) / 4) / 100

round(100 * (unaryPlus(prop("Discuss")) + unaryPlus(prop("Procedures")) + unaryPlus(prop("Review")) + unaryPlus(prop("Final")) + unaryPlus(prop("Column")) + unaryPlus(prop("Column 1"))) / 6) / 100

dateBetween 8:56 (sign, now)

dateBetween(prop("Deadline"), now(), "days")

dateBetween(prop("Deadline"), now(), "hours") / 24

ceil(dateBetween(prop("Deadline"), now(), "hours") / 24)

sign(ceil(dateBetween(prop("Deadline"), now(), "hours") / 24))

now()

Past, Present Future pt.1 13:21

ceil(dateBetween(prop("Deadline"), now(), "hours") / 24) == 0

prop("Deadline") < now()

prop("Deadline") > now()

If Statements 15:10

(prop("#") == 1 ? "1": "")

if(2 > 0, "A", if(3 > 2, "B", ""))

if(prop("#") > 2, "A", if(prop("#") > 0, "B", ""))

if(prop("#") > 2, "A", if(prop("#") == 2, "C", if(prop("#") > 0, "B", "")))

Past, Present, Future pt.2 (abs, format) 18:08

if(ceil(dateBetween(prop("Deadline"), now(), "hours") / 24) == 0, "Today", if(prop("Deadline") < now(), "Past", if(prop("Deadline") > now(), "Future", "")))

abs(ceil(dateBetween(prop("Deadline"), now(), "hours") / 24))

format(abs(ceil(dateBetween(prop("Deadline"), now(), "hours") / 24)))

if(ceil(dateBetween(prop("Deadline"), now(), "hours") / 24) == 0, "🔺Today", if(prop("Deadline") < now(), format(abs(ceil(dateBetween(prop("Deadline"), now(), "hours") / 24))) + " 🔙Days Past", if(prop("Deadline") > now(), format(abs(ceil(dateBetween(prop("Deadline"), now(), "hours") / 24))) + " 🔜Days Remaining", "")))

Priority Formula (contains, toNumber) 21:25

contains(prop("Past, Present, Future"), "Today")

contains(prop("Past, Present, Future"), "Today") or contains(prop("Past, Present, Future"), "Days Remaining")

toNumber(prop("Past, Present, Future"))

if(contains(prop("Past, Present, Future"), "Today") and prop("Complete") < 1, "URGENT!", if(contains(prop("Past, Present, Future"), "Days Remaining") and toNumber(prop("Past, Present, Future")) <= 8 and prop("Complete") < .5, "PRIORITY!", if(prop("Complete") == 1, "ARCHIVE!", "")))