🎁

Holiday Budgeting With Notion

Created
Nov 30, 2020 12:50 AM
↙️
Hi, Hello! My name is Sarah - the writer behind redgregory.com.
notion image
πŸ”°
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

notion image

Price Of Each Gift Calculates To A Sum Next To Each Name

  • This is achieved through a column configuration (...).
notion image

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", ""))
notion image
notion image

πŸ“Š Highest Performing Tweet

🧠 My Mood Last Week

Content Published This Week

Video preview