Derived Relations (Formulas)

This is so essential that I was surprised it wasn’t already supported. Some of the ways I’ve used it in Notion:

  • progress bars, like percentage of completed tasks within an epic
  • formatting raw columns into display columns
  • date manipulation (like calculating next due date based on last done date)
  • converting dates to durations (which update dynamically with a now() value)
  • combining multiple columns into a single score value
  • combining multiple columns into a single column that can then be used to filter a view
  • unit conversions (F to C, in to cm, etc)
  • and of course, simple accounting calculations

Really opens things up. This and support for Mermaid.js are my biggest reasons I can’t move from Notion yet.

Screen Shot 2023-12-09 at 15.32.02

Screen Shot 2023-12-09 at 15.31.14