Notion Templates
Notion Templates/
All Templates
All Templates/
Date Progress Status
Date Progress Status
Date Progress Status

Date Progress Status

Master Tag
Tips & Tricks
Created
Jan 12, 2021 04:04 AM
How It Works
https://www.redgregory.com/notion/2021/1/13/notion-formula-track-progress-for-the-year-month-and-day
Usage
Slice
formateDate
toNumber
Year
Month
Hour
Web Tags
Formula
Alternatives
🎚️
Slider Progress Bar
⌨️
Slider Progress Bar Use-Cases
Cover
Week Of Month (13).png

Donate

Formulas

Year Formula

if(10 * toNumber(formatDate(now(), "DDD")) / 365 < 1, "▒░░░░░░░░░ " + format(floor(100 * toNumber(formatDate(now(), "DDD")) / 365)) + "%", if(year(now()) % 4 == 0, slice("▒▒▒▒▒▒▒▒▒▒", 0, 10 * toNumber(formatDate(now(), "DDD")) / 366) + slice("░░░░░░░░░░", 10 * toNumber(formatDate(now(), "DDD")) / 366) + " " + format(floor(100 * toNumber(formatDate(now(), "DDD")) / 366)) + "%", slice("▒▒▒▒▒▒▒▒▒▒", 0, 10 * toNumber(formatDate(now(), "DDD")) / 365) + slice("░░░░░░░░░░", 10 * toNumber(formatDate(now(), "DDD")) / 365) + " " + format(floor(100 * toNumber(formatDate(now(), "DDD")) / 365)) + "%"))

Month Formula

if(year(now()) % 4 == 0 and month(now()) == 1, slice("▒▒▒▒▒▒▒▒▒▒", 0, 10 * toNumber(formatDate(now(), "D")) / 29) + slice("░░░░░░░░░░", 10 * toNumber(formatDate(now(), "D")) / 29) + " " + format(floor(100 * toNumber(formatDate(now(), "D")) / 29)) + "%", if(month(now()) == 0 or month(now()) == 2 or month(now()) == 4 or month(now()) == 6 or month(now()) == 7 or month(now()) == 9 or month(now()) == 11, slice("▒▒▒▒▒▒▒▒▒▒", 0, 10 * toNumber(formatDate(now(), "D")) / 31) + slice("░░░░░░░░░░", 10 * toNumber(formatDate(now(), "D")) / 31) + " " + format(floor(100 * toNumber(formatDate(now(), "D")) / 31)) + "%", if(month(now()) == 1, slice("▒▒▒▒▒▒▒▒▒▒", 0, 10 * toNumber(formatDate(now(), "D")) / 28) + slice("░░░░░░░░░░", 10 * toNumber(formatDate(now(), "D")) / 28) + " " + format(floor(100 * toNumber(formatDate(now(), "D")) / 28)) + "%", if(month(now()) == 1 or month(now()) == 3 or month(now()) == 5 or month(now()) == 8 or month(now()) == 10, slice("▒▒▒▒▒▒▒▒▒▒", 0, 10 * toNumber(formatDate(now(), "D")) / 30) + slice("░░░░░░░░░░", 10 * toNumber(formatDate(now(), "D")) / 30) + " " + format(floor(100 * toNumber(formatDate(now(), "D")) / 30)) + "%", ""))))

Week Formula

if(day(now()) == 0, "▒▒▒▒▒▒▒▒▒▒ 100% ", slice("▒▒▒▒▒▒▒▒▒▒", 0, 10 * day(now()) / 7) + slice("░░░░░░░░░░", 10 * day(now()) / 7) + " " + format(floor(100 * day(now()) / 7)) + "%")

Day Formula

if(10 * hour(now()) / 24 < 1, "▒░░░░░░░░░ " + format(floor(100 * hour(now()) / 24)) + "%", slice("▒▒▒▒▒▒▒▒▒▒", 0, 10 * hour(now()) / 24) + slice("░░░░░░░░░░", 10 * hour(now()) / 24) + " " + format(floor(100 * hour(now()) / 24)) + "%")