Notion 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)
Name
Today
This Week
This Month
This Year
Indicator Progress Bar w/ Percentage
Colorful Progress Bar (Habits)
Name
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit Progress
% (Hide)
Indicator Progress Bar w/ Percentage
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Colorful Progress Bar (Bookshelf)
Name
Total Pages
Pages Read
Book Progress
Indicator Progress Bar w/ Percentage
455
116

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)
Name
Today
This Week
This Month
This Year
Colorful Progress Bar w/ Percentage
Colorful Progress Bar v.2 (Habits)
Name
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Habit Progress
% (Hide)
Colorful Progress Bar w/ Percentage
Habit 1
Habit 2
Habit 3
Habit 4
Habit 5
Habit 6
Colorful Progress Bar v.2 (Bookshelf)
Name
Total Pages
Pages Read
Book Progress
Colorful Progress Bar w/ Percentage
500
400

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