BASES - Relative Progress Bars

1 min read

Setup

  • You need two numeric properties (e.g. estimatedEffort and currentEffort) in your notes
  • In your base, click on Properties, Add Formula, and give it a name (e.g. fPercentage)
    • Copy/paste the first code snippet from below
  • Create another property (e.g., fProgressBar)
    • Copy/paste the second code snippet from below
  • You can replace the emojis in the formula with whatever you prefer

Result

You get a view like this:

Bases table with emoji progress bars showing current versus estimated effort per note

Code

Snippet 1 - fPercentage

(currentEffort / estimatedEffort * 100).round(1)

Snippet 2 - fProgressBar

("🟩".repeat(((formula.fPercentage / 100) * 10).round(0)) + "⬛".repeat(((100 - formula.fPercentage) / 100 * 10).floor()))

Source

Backlinks