With this table I track the progress of my essays & papers. I have created two formulas, which function as a written pages progres bar & a deadline countdown.
When adding a new coloumn choose “Formula” as property type and paste the following into the empty field:
slice("●●●●●●●●●●", 0, round(prop("Written") / prop("Total") * 10)) + slice("○○○○○○○○○○", 0, round((1 - prop("Written") / prop("Total")) * 10)) + " " + if(prop("Written") == 0, "0", format(round(prop("Written") / prop("Total") * 100))) + "%”
In order for the formula to work, there need to be coloumns named “Written” and “Total” - If you want to rename these columns, do so after you have already created the formula column (the formula will automatically change).
When adding a new coloumn choose “Formula” as property type and paste the following into the empty field:
empty(prop("Deadline")) ? "" : concat(format(abs(dateBetween(prop("Deadline"), now(), "days")) + 1), format((dateBetween(prop("Deadline"), now(), "days") + 1 <= 0) ? " days overdue" : ((dateBetween(prop("Deadline"), now(), "days") + 1 > 0) ? " days remaining" : "")))
In order for the formula to work, there need to be a coloumn named “Deadline”, which has the “Date” format - If you want to rename this column, do so after you have already created the formula column (the formula will automatically change).