Progress Dashboard formula
Count the 'percentage' of my goal progress in the dashboard
round(prop("Done") / prop("Target") * 100) / 100
Generate a 'visual progress bar' based on the 'percentage' of my goal progress
slice("▓▓▓▓▓▓▓▓▓▓", 0, round(prop("Percentage") * 10)) + slice("░░░░░░░░░░", 0, round((.999 - prop("Percentage")) * 10)) + " " + if(prop("Percentage") == 0, "0", format(round(prop("Percentage") * 100))) + "%"
slice("◾◾◾◾◾◾◾◾◾◾", 0, round(prop("Percentage") * 10)) + slice("◻◻◻◻◻◻◻◻◻◻", 0, round((.999 - prop("Percentage")) * 10)) + " " + if(prop("Percentage") == 0, "0", format(round(prop("Percentage") * 100))) + "%"
slice("⚫⚫⚫⚫⚫⚫⚫⚫⚫⚫", 0, round(prop("Percentage") * 10)) + slice("◯◯◯◯◯◯◯◯◯◯", 0, round((.999 - prop("Percentage")) * 10)) + " " + if(prop("Percentage") == 0, "0", format(round(prop("Percentage") * 100))) + "%"
Finance Tracker formula
Calculate the difference of value between 2 numbers, i.e. Income is 1000 vs. Spending is 5000
prop("Income") - prop("Spending")
result is -4000
If there's an INCREASE in value between two numbers, please automatically pop up a checkbox for me. I.e. Last Month my income is 50,000 and This Month is 55,000
prop("Last Month") < prop("This Month")
If there's a DECREASE in value between two numbers, please uncheck a checkbox for me. I.e. Last Month my income is 40,000 and This Month is 35,000
prop("Last Month") > prop("This Month")
Habit Tracker formula
Automatically pop up a "Day" label from a "Date" entry
formatDate(prop("Date"), "ddd")
result is Mon, Tue, Wed...