Hi, Hello! My name is Sarah - the writer behind redgregory.com.
The holidays are coming up, and the Notion Boardview database is perfect for gift budgeting. Here is how the template works.
A Boardview Divided By Gift Receiver
Price Of Each Gift Calculates To A Sum Next To Each Name
- This is achieved through a column configuration (...).
The Budget Database Keeps Track Of Expenses
- Total Cost of all gifts, with exception for money Chipped In from other people , is subtracted from the overall Budget. What returns in the cell is if you are over or under budget as new gifts are added to the database.
FORMULA:
if(prop("Total Cost") - prop("Chip In") > prop("Budget"), "βοΈOver Budget" + "\n$" + format(round(abs(prop("Budget") - (prop("Total Cost") - prop("Chip In"))))) + " Over", if(prop("Total Cost") - prop("Chip In") <= prop("Budget"), "β In Budget" + "\n$" + format(round(prop("Budget") - (prop("Total Cost") - prop("Chip In")))) + " Left", ""))