A Savings Dashboard

A Savings Dashboard

Master Tag
Productivity
Created
Feb 4, 2022 12:53 AM
Usage
Web Tags
Dashboard
How To
Formula
Cover
Untitled_Artwork 9.png
Follow Along
Follow Along

Donate

⚠️
Delete entries in each database to clear template
 
 
Original Databases
Formulas
Total Spent
if(not empty(prop("Custom")), prop("Custom"), prop("Minimum"))
Months Left
if(empty(prop("Started Saving")) and prop("Cost") > 0, ceil(prop("Cost") / prop("Save per Month")), if(not empty(prop("Started Saving")) and prop("Cost") > 0, ceil((prop("Cost") - prop("Total Saved")) / prop("Save per Month")), toNumber("")))
Projected End
if(prop("Months Left") == 0, "✅ Achieved Savings Goal", if(not empty(prop("Months Left")), "Paid for by " + formatDate(dateAdd(now(), prop("Months Left"), "months"), "LL"), ""))
Left to Save
prop("Cost") - prop("Total Saved")