Donate
What is this formula doing?
If deadline is within the next week, show the day of the week it is due.
If not ... show blank space.
I suggest filtering a separate view for upcoming deadlines → Day For Upcoming Tasks is not empty
Formulas
Progress Bar → Weekday now
"◀" + concat(slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 3 * day(now()) + 1), formatDate(now(), "ddd"), slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 21 - 3 * day(now()) - 2)) + "▶︎"
Progress Bar → Weekday of deadline
"◀" + concat(slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 3 * day(prop("Deadline")) +1), formatDate(prop("Deadline"), "ddd"), slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 21 - 3 * day(prop("Deadline")) - 2)) + "▶︎"
Progress Bar → Weekday of deadline only if due within this week (Start Sunday)
if(dateBetween(prop("Deadline"), now(), "days") + 1 < 7 and dateBetween(prop("Deadline"), now(), "days") + 1 > -1, "◀" + concat(slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 3 * day(prop("Deadline")) + 1), formatDate(prop("Deadline"), "ddd"), slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 21 - 3 * day(prop("Deadline")) - 2)) + "▶︎", "")
Progress Bar → Weekday of deadline only if due within this week (Start Monday)
if(dateBetween(prop("Deadline"), now(), "days") + 1 < 7 and dateBetween(prop("Deadline"), now(), "days") + 1 > 0 and day(prop("Deadline")) == 0, "‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒Sun▶︎", if(dateBetween(prop("Deadline"), now(), "days") + 1 < 7 and dateBetween(prop("Deadline"), now(), "days") + 1 > 0, concat(slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 3 * day(prop("Deadline")) - 2), formatDate(prop("Deadline"), "ddd")) + "▶︎", ""))
Formula Design → Upcoming Deadlines (Start Sunday)
Formula Design → Upcoming Deadlines (Start Monday)