Notion Cheat Sheet



Probability Cheat Sheet Distributions Unifrom Distribution notation Ua;b cdf x a b a for x2a;b pdf 1 b a for x2a;b expectation 1 2 (a+ b) variance 1 12 (b a)2 mgf etb eta t(b a) story: all intervals of the same length on the distribution’s support are equally probable. Gamma Distribution notation Gamma(k; ) pdf kx 1e x ( k) I x0 ( k. The Notion Formula Cheat Sheet. Simple, Useful Formula Examples. Notion Formulas: Prioritize Tasks Automatically. Notion Formulas: Create a Progress Bar.

formatDate(prop('Date'), 'w')

Week # Starting Sunday (1-52)

formatDate(prop('Date'), 'W')

Week # Starting Monday (1-52)

formatDate(prop('Date'), 'Y')

YYYY (2021)

formatDate(prop('Date'), 'YY')

YY (21)

formatDate(prop('Date'), 'a')

am/pm

formatDate(prop('Date'), 'A')

AM/PM

formatDate(prop('Date'), 'd')

Weekday #

formatDate(prop('Date'), 'dd')

Weekday (Fr)

formatDate(prop('Date'), 'ddd')

Weekday (Fri)

formatDate(prop('Date'), 'dddd')

Weekday (Friday)

formatDate(prop('Date'), 'D')

Date (1/3/21)

formatDate(prop('Date'), 'DD')

Date (1/03/21)

formatDate(prop('Date'), 'DDD')

Day # of the Year

formatDate(prop('Date'), 'h')

Hour standard (4:13 pm)

formatDate(prop('Date'), 'H')

24-Hour time (16:13 pm)

  • 12am = 0

formatDate(prop('Date'), 'k')

24-Hour time (16:13 pm)

  • 12am = 24

formatDate(prop('Date'), 'l')

M/D/YYYY (1/3/2021)

formatDate(prop('Date'), 'll')

MMM D, YYYY (Mar 3, 2021)

formatDate(prop('Date'), 'lll')

MMM D, YYYY h:mm A (Mar 3, 2021 1:40 AM)

formatDate(prop('Date'), 'llll')

ddd, MMM D, YYYY h:mm A (Wed, Mar 3, 2021 1:40 AM)

formatDate(prop('Date'), 'L')

MM/DD/YYYY (03/01/21)

formatDate(prop('Date'), 'LL')

MMMM D, YYYY (March 3, 2021)

formatDate(prop('Date'), 'LLL')

MMMM D, YYYY h:mm A (March 3, 2021 1:40 AM)

formatDate(prop('Date'), 'LLLL')

dddd, MMMM D, YYYY h:mm A (Wednesday, March 3, 2021 1:40 PM)

formatDate(prop('Date'), 'LT')

Time (h:mm A → 3:03 PM)

formatDate(prop('Date'), 'z')

Timezone (EDT)

formatDate(prop('Date'), 'Z')

Timezone Offset (-4:00)

formatDate(prop('Date'), 'ZZ')

Timezone Offset (-0400)

Sheet

Limitation: seconds are not recorded in timestamps

Idea Cheat Sheet

formatDate(prop('Date'), 'X')

Unix timestamp (1616731200)

formatDate(prop('Date'), 'm')

Minute (12:03 PM)

formatDate(prop('Date'), 'mm')

Minute (12:03 PM)

formatDate(prop('Date'), 'M')

Month (4/13/21)

formatDate(prop('Date'), 'MM')

Month (04/13/21)

formatDate(prop('Date'), 'MMM')

Month (Apr)

formatDate(prop('Date'), 'MMMM')

Month (April)

formatDate(prop('Date'), 'dddd [the] Do [of] MMMM')

Notion formula cheat sheet

Notion Date Formula

Friday the 16th of May

formatDate(prop('Date'), 'llll z')

Wed, Mar 3, 2021 1:40 AM EST

formatDate(prop('Date'), 'YYYY-MM-DD[T]HH:mm:X')

Notion Formula Today

2021-03-17T13:03:1616000580

Notion Formula Cheat Sheet

formatDate(prop('Date'), 'LT zZ')

Notation Cheat Sheet

1:40 PM EDT-04:00

Extra Tips

Formulas In Notion

  • Add (..th..st..rd) to numbers with 'o'

    • [ex. formatDate(prop('Date'), 'Qo') = 3rd]

  • Turn format into a numerical value: wrap with toNumber()

    • [ex. toNumber(formatDate(prop('Date'), 'Q'))]