Use-Cases For The Newest Update
Habits Formulas
floor(100 * (toNumber(prop("Habit 1")) + toNumber(prop("Habit 2")) + toNumber(prop("Habit 3")) + toNumber(prop("Habit 4")) + toNumber(prop("Habit 5"))) / 5) / 100
toNumber(prop("Habit 1")) + toNumber(prop("Habit 2")) + toNumber(prop("Habit 3")) + toNumber(prop("Habit 4")) + toNumber(prop("Habit 5"))
Progress Bar Functionality
Project and Task Formulas
floor(100 * prop("Not Started")) / 100
floor(100 * prop("In Progress")) / 100
floor(100 * prop("Done")) / 100
Progress Bar w/ Rollups
Tasks
Status
Name
Project
Deadline
Cap progress @ 100% Formulas
floor(1000 * dateBetween(now(), start(prop("Date Range")), "days") / dateBetween(end(prop("Date Range")), start(prop("Date Range")), "days")) / 1000
if(prop("Percentage (Hide)") < 0, 0, if(prop("Percentage (Hide)") > 1, 1, prop("Percentage (Hide)")))
Cap Progress Bar @ 100%
Daily Progress Formula
if(formatDate(prop("Date"), "LL") == formatDate(now(), "LL"), hour(now()) + minute(now()) / 60, if(prop("Date") < now(), 24, 0))
Daily Progress Bar