**Due Next Formula**
if(prop("Repeats?") == "Weekly", dateAdd(prop("Date(s)"), 7, "days"), if(prop("Repeats?") == "Bi-Weekly", dateAdd(prop("Date(s)"), 14, "days"), if(prop("Repeats?") == "Monthly", dateAdd(prop("Date(s)"), 30, "days"), if(prop("Repeats?") == "Bi-Monthly", dateAdd(prop("Date(s)"), 60, "days"), if(prop("Repeats?") == "Quarterly", dateAdd(prop("Date(s)"), 90, "days"), if(prop("Repeats?") == "Semi-Annually", dateAdd(prop("Date(s)"), 180, "days"), if(prop("Repeats?") == "Never", dateAdd(prop("Date(s)"), 0, ""), dateAdd(prop("Date(s)"), 1, "years"))))))))
**Appreciation/Depreciation Formula**
if(prop("Present Value Multiplier") == 1, prop("Purchase Price") * 1.02, if(prop("Present Value Multiplier") == 2, prop("Purchase Price") * 1.04, if(prop("Present Value Multiplier") == 3, prop("Purchase Price") * 1.06, if(prop("Present Value Multiplier") == 4, prop("Purchase Price") * 1.08, if(prop("Present Value Multiplier") == 5, prop("Purchase Price") * 1.1, if(prop("Present Value Multiplier") == 6, prop("Purchase Price") * 1.12, if(prop("Present Value Multiplier") == 7, prop("Purchase Price") * 1.14, if(prop("Present Value Multiplier") == 8, prop("Purchase Price") * 1.10, if(prop("Present Value Multiplier") == 9, prop("Purchase Price") * 1.08, if(prop("Present Value Multiplier") == 10, prop("Purchase Price") * 1.06, if(prop("Present Value Multiplier") == 11, prop("Purchase Price") * 1.04, if(prop("Present Value Multiplier") == 12, prop("Purchase Price") * 1.02, prop("Purchase Price") * 1))))))))))))
Habit Tracker Formula
replace(replaceAll(replaceAll(replaceAll(replaceAll(slice("122333444", toNumber(prop("Brush Your Teeth")) + toNumber(prop("Have 1 Coffee")) + toNumber(prop("Only 1 Stick of Gum")) + toNumber(prop("Eat a Healthy Lunch")) + toNumber(prop("Help with Dishes")) + toNumber(prop("Kiss the Mrs")) + toNumber(prop("Exercisea")) + toNumber(prop("Read for 5 Minutes")) + toNumber(prop("Kiss the Mrs")) - 1, toNumber(prop("Brush Your Teeth")) + toNumber(prop("Have 1 Coffee")) + toNumber(prop("Only 1 Stick of Gum")) + toNumber(prop("Eat a Healthy Lunch")) + toNumber(prop("Help with Dishes")) + toNumber(prop("Drink Only 1 Soda")) + toNumber(prop("Read for 5 Minutes")) + toNumber(prop("Exercisea")) + toNumber(prop("Kiss the Mrs"))), "1", "🔴"), "2", "🟠"), "3", "🟡"), "4", "🟢") + "   " + format((toNumber(prop("Brush Your Teeth")) + toNumber(prop("Have 1 Coffee")) + toNumber(prop("Only 1 Stick of Gum")) + toNumber(prop("Eat a Healthy Lunch")) + toNumber(prop("Help with Dishes")) + toNumber(prop("Exercisea")) + toNumber(prop("Drink Only 1 Soda")) + toNumber(prop("Read for 5 Minutes")) + toNumber(prop("Kiss the Mrs"))) / 9 * 100) + "%", "-  0%", "🚫 - 0%")