🚗 Date Progress Bar
Find percentage of completion inside a Notion date range. In this tutorial, I will show you how to find percentage of a date range complete in relation to today and how to incorporate an emoji progress bar. What this formula returns: If date range includes today, return percentage of range complete. Otherwise, leave cell blank.
Step 1: Create A Date Range Property
Step 2: Find Percentage Of Range Complete
Insert name of date property created above where it applies.
(divide(dateBetween(now(), start(prop("INSERT PROPERTY NAME")), "days"), dateBetween(end(prop("INSERT PROPERTY NAME")), start(prop("INSERT PROPERTY NAME")), "days")) > 0) ? (round(100 * divide(dateBetween(now(), start(prop("INSERT PROPERTY NAME")), "days"), dateBetween(end(prop("INSERT PROPERTY NAME")), start(prop("INSERT PROPERTY NAME")), "days"))) / 100) : toNumber("")
Breakdown
(divide(dateBetween(now(), start(prop("INSERT PROPERTY NAME")), "days"), dateBetween(end(prop("INSERT PROPERTY NAME")), start(prop("INSERT PROPERTY NAME")), "days"))
Divide two following results:
Find number of days between the start of the range and today.
Find total number of days inside the range.
> 0) ?
If result of division is greater than 0 … (signaling that today is within the range)
(round(100 * divide(dateBetween(now(), start(prop("INSERT PROPERTY NAME")), "days"), dateBetween(end(prop("INSERT PROPERTY NAME")), start(prop("INSERT PROPERTY NAME")), "days"))) / 100)
… If greater than 0, display this calculation:
Divide two following results:
Find number of days between the start of the range and today.
Find total number of days inside the range.
… And round result of division (more about rounding numbers here)
: toNumber("")
Otherwise, create an empty space
An Emoji Alternative
More about progress bar and the slice function here.
if(dateBetween(end(prop("Date 2")), now(), "days") < 0, slice("⌬⌬⌬⌬⌬⌬⌬⌬⌬✓", 0, dateBetween(now(), start(prop("Date 2")), "days") / dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days") * 10) + " " + "100%", if(divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days")) > 0, slice("⌬⌬⌬⌬⌬⌬⌬⌬⌬✓", 0, dateBetween(now(), start(prop("Date 2")), "days") / dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days") * 10) + " " + format(round(divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days")) * 100)) + "%", ""))
