If you're running a business in Notion, these 5 formulas will save you hours every week. Copy them directly into your databases.

---

1. Auto-Calculate Profit Margin

round((prop("Revenue") - prop("Costs")) / prop("Revenue") * 100)

Drop this into any project tracker. Instantly see which clients/products are actually profitable vs. just keeping you busy.

---

2. Days Until Deadline (with color coding)

dateBetween(prop("Due Date"), now(), "days")

Pair this with a conditional format:

• 🔴 < 3 days = urgent

• 🟡 3-7 days = plan it

• 🟢 7+ days = you're good

Never miss a deadline again.

---

3. Recurring Revenue Tracker

if(prop("Status") == "Active", prop("Monthly Rate") * 12, 0)

Add this to your client database to instantly see your projected annual revenue from active contracts only. Filters out churned clients automatically.

---

4. Task Priority Score

(if(prop("Impact") == "High", 3, if(prop("Impact") == "Medium", 2, 1))) * (if(prop("Urgency") == "High", 3, if(prop("Urgency") == "Medium", 2, 1)))

This creates a 1-9 scoring system. Sort by this column descending and you always know what to work on next. No more decision fatigue.

---

5. Auto-Status Based on Dates

if(empty(prop("Start Date")), "Not Started", if(now() > prop("Due Date"), "Overdue", if(now() >= prop("Start Date"), "In Progress", "Scheduled")))

Your projects update themselves. No more manually changing statuses.

---

Pro tip: Combine formulas #1 and #3 in a single dashboard and you'll have a real-time snapshot of your business health without opening a spreadsheet.

Want templates with these formulas already built in? Check out the Business OS — it's got all of this pre-configured and ready to go.

Drop a comment if you want me to cover more Notion formulas 👇