Hi, Hello! My name is Sarah - the writer behind redgregory.com.
I want to explore different fun and cute ways to approach progress bars in Notion. I also plan to write an article about a few ideas. Here is a package tracking formula I thought may be a nice place to start. For this formula, I used the following:
- Paid → Latest Delivery (date range): Date from day paid to approximate delivery date.
- Progress (formula): This is the formula that calculates the days between now and the estimated delivery time.
Packages to Track
Name
Paid → Latest Delivery
Progress
Formula
if(formatDate(end(prop("Paid → Latest Delivery")), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY"), "☗☗☗☗☗☗☗☗☗☗🏠", if(dateBetween(end(prop("Paid → Latest Delivery")), now(), "days") > -1, slice("☗☗☗☗☗☗☗☗☗☗", 0, floor(10 * dateBetween(now(), start(prop("Paid → Latest Delivery")), "days") / dateBetween(end(prop("Paid → Latest Delivery")), start(prop("Paid → Latest Delivery")), "days"))) + "📦" + slice("☖☖☖☖☖☖☖☖☖☖", 0, 10 - floor(10 * dateBetween(now(), start(prop("Paid → Latest Delivery")), "days") / dateBetween(end(prop("Paid → Latest Delivery")), start(prop("Paid → Latest Delivery")), "days"))), ""))
My Mood
access
Content Published The Past Two Weeks
