Notion TemplatesNotion Templates
Notion Templates/
All Templates
All Templates/
Colorful Progress Bar
Colorful Progress Bar
Colorful Progress Bar

Colorful Progress Bar

Master Tag
Tips & Tricks
Created
May 4, 2022 11:21 PM
How It Works
Usage
Less Than
Slice
Format
Hour
unaryPlus
floor
Web Tags
Formula
Database
How To
Alternatives
Cover
Date Percetages

Slider Progress Bar

 
Formulas
"🟥🟥🟥🟨🟨🟨🟨🟩🟩🟩 " + format(floor(1000 * hour(now()) / 23) / 10) + "%" + "\n" + slice("▔▔▔▔▔▔▔▔▔▔", 0, 10 * hour(now()) / 23) + "^"
Today
"🟥🟥🟥🟨🟨🟨🟨🟩🟩🟩 " + format(floor(1000 * date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days"))) / 10) + "%" + "\n" + slice("▔▔▔▔▔▔▔▔▔▔", 0, 10 * date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days"))) + "^"
This Month
"🟥🟥🟥🟨🟨🟨🟨🟩🟩🟩 " + format(floor(1000 * prop("Pages Read") / prop("Total Pages")) / 10) + "%" + "\n" + slice("▔▔▔▔▔▔▔▔▔▔", 0, 10 * prop("Pages Read") / prop("Total Pages")) + "^"
Book Progress
✂️
Change Names of Properties
  1. Make property called Total Pages
  1. Make another called Pages Read.
  1. Paste the above formula.
  1. Change the names of the two properties and formula will automatically update.
if(day(now()) != 0, "🟥🟥🟥🟨🟨🟨🟨🟩🟩🟩 " + format(floor(1000 * day(now()) / 7) / 10) + "%" + "\n" + slice("▔▔▔▔▔▔▔▔▔▔", 0, 10 * day(now()) / 7) + "^", "🟥🟥🟥🟨🟨🟨🟨🟩🟩🟩 100%" + "\n" + "▔▔▔▔▔▔▔▔▔^")
This Week
"🟥🟥🟥🟨🟨🟨🟨🟩🟩🟩 " + format(floor(1000 * (month(now()) + 1) / 12) / 10) + "%" + "\n" + slice("▔▔▔▔▔▔▔▔▔▔", 0, 10 * (month(now()) + 1) / 12) + "^"
This Year
"🟥🟥🟥🟨🟨🟨🟨🟩🟩🟩 " + format(floor(1000 * prop("% (Hide)")) / 10) + "%" + "\n" + slice("▔▔▔▔▔▔▔▔▔▔", 0, 10 * prop("% (Hide)")) + "^"
Habit Progress with 6 habits
✂️
Change number of habits
Inside the % (Hide) property, add another unaryPlus("Habit Title") to find sum of all habits, then divide the result by the new total # of habits.
(unaryPlus(prop("Habit 1")) + unaryPlus(prop("Habit 2")) + unaryPlus(prop("Habit 3")) + unaryPlus(prop("Habit 4")) + unaryPlus(prop("Habit 5")) + unaryPlus(prop("Habit 6"))) / 6
Colorful Progress Bar (Dates)
Colorful Progress Bar (Habits)
Colorful Progress Bar (Bookshelf)

Progressive Color Bar

 
Formulas
if(hour(now()) / 23 < 0.2, "🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(hour(now()) / 23 < 0.3, "🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(hour(now()) / 23 < 0.4, "🟥🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(hour(now()) / 23 < 0.5, "🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️⬜️", if(hour(now()) / 23 < 0.6, "🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️", if(hour(now()) / 23 < 0.7, "🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️", if(hour(now()) / 23 < 0.8, "🟨🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️", if(hour(now()) / 23 < 0.9, "🟩🟩🟩🟩🟩🟩🟩🟩⬜️⬜️", if(hour(now()) / 23 < 1, "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️", "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️"))))))))) + "  " + format(floor(1000 * hour(now()) / 23) / 10) + "%"
Today
if(date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")) < 0.2, "🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")) < 0.3, "🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")) < 0.4, "🟥🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")) < 0.5, "🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️⬜️", if(date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")) < 0.6, "🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️", if(date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")) < 0.7, "🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️", if(date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")) < 0.8, "🟨🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️", if(date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")) < 0.9, "🟩🟩🟩🟩🟩🟩🟩🟩⬜️⬜️", if(date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days")) < 1, "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️", "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️"))))))))) + " " + format(floor(1000 * date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days"))) / 10) + "%"
This Month
if(prop("Pages Read") / prop("Total Pages") < 0.2, "🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(prop("Pages Read") / prop("Total Pages") < 0.3, "🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(prop("Pages Read") / prop("Total Pages") < 0.4, "🟥🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(prop("Pages Read") / prop("Total Pages") < 0.5, "🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️⬜️", if(prop("Pages Read") / prop("Total Pages") < 0.6, "🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️", if(prop("Pages Read") / prop("Total Pages") < 0.7, "🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️", if(prop("Pages Read") / prop("Total Pages") < 0.8, "🟨🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️", if(prop("Pages Read") / prop("Total Pages") < 0.9, "🟩🟩🟩🟩🟩🟩🟩🟩⬜️⬜️", if(prop("Pages Read") / prop("Total Pages") < 1, "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️", "🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩"))))))))) + " " + format(floor(1000 * prop("Pages Read") / prop("Total Pages")) / 10) + "%"
Book Progress
✂️
Change Names of Properties
  1. Make property called Total Pages
  1. Make another called Pages Read.
  1. Paste the above formula.
  1. Change the names of the two properties and formula will automatically update.
if(day(now()) == 0, "🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 " + format(floor(1000 * day(now()) / 7) / 10) + "%", if(day(now()) / 7 < 0.2, "🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(day(now()) / 7 < 0.3, "🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(day(now()) / 7 < 0.4, "🟥🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(day(now()) / 7 < 0.5, "🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️⬜️", if(day(now()) / 7 < 0.6, "🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️", if(day(now()) / 7 < 0.7, "🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️", if(day(now()) / 7 < 0.8, "🟨🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️", if(day(now()) / 7 < 0.9, "🟩🟩🟩🟩🟩🟩🟩🟩⬜️⬜️", if(day(now()) / 7 < 1, "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️", "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️"))))))))) + " " + format(floor(1000 * day(now()) / 7) / 10) + "%")
This Week
if((month(now()) + 1) / 12 < 0.2, "🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if((month(now()) + 1) / 12 < 0.3, "🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if((month(now()) + 1) / 12 < 0.4, "🟥🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if((month(now()) + 1) / 12 < 0.5, "🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️⬜️", if((month(now()) + 1) / 12 < 0.6, "🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️", if((month(now()) + 1) / 123 < 0.7, "🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️", if((month(now()) + 1) / 12 < 0.8, "🟨🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️", if((month(now()) + 1) / 12 < 0.9, "🟩🟩🟩🟩🟩🟩🟩🟩⬜️⬜️", if((month(now()) + 1) / 12 < 1, "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️", "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️"))))))))) + " " + format(floor(1000 * (month(now()) + 1) / 12) / 10) + "%"
This Year
if(prop("% (Hide)") < 0.2, "🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(prop("% (Hide)") < 0.3, "🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(prop("% (Hide)") < 0.4, "🟥🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(prop("% (Hide)") < 0.5, "🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️⬜️", if(prop("% (Hide)") < 0.6, "🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️", if(prop("% (Hide)") < 0.7, "🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️", if(prop("% (Hide)") < 0.8, "🟨🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️", if(prop("% (Hide)") < 0.9, "🟩🟩🟩🟩🟩🟩🟩🟩⬜️⬜️", if(prop("% (Hide)") < 1, "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️", "🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩"))))))))) + " " + format(floor(1000 * prop("% (Hide)")) / 10) + "%"
Habit Progress with 6 habits
✂️
Change number of habits
Inside the % (Hide) property, add another unaryPlus("Habit Title") to find sum of all habits, then divide the result by the new total # of habits.
(unaryPlus(prop("Habit 1")) + unaryPlus(prop("Habit 2")) + unaryPlus(prop("Habit 3")) + unaryPlus(prop("Habit 4")) + unaryPlus(prop("Habit 5")) + unaryPlus(prop("Habit 6"))) / 6
Colorful Progress Bar v.2 (Dates)
Colorful Progress Bar v.2 (Habits)
Colorful Progress Bar v.2 (Bookshelf)

Date Percetages

hour(now()) / 23
Find progress for today
if(day(now()) != 0, day(now()) / 7, 1)
Find progress for this week
date(now()) / date(dateSubtract(dateAdd(dateSubtract(now(), date(now()) - 1, "days"), 1, "months"), 1, "days"))
Find progress for this month
(month(now()) + 1) / 12
Find progress for this year