The Formula Column in monday.com enables you to perform real-time calculations using data from other columns. It’s a powerful feature for tracking budgets, calculating time differences, managing KPIs, and more—right inside your boards.

---

🧮 What Is the Formula Column?

The Formula Column allows you to create custom calculations by referencing other columns and using arithmetic operations, functions, and logical expressions.

Example Use Cases:

• Calculate total cost = Quantity * Unit Price
• Track time left = Deadline - Today()
• Show overdue status = IF(Today() > {Due Date}, "Overdue", "On Track")

---

🛠️ How to Add a Formula Column

Step 1: Open Your Board

Navigate to the board where you want to perform calculations.

Step 2: Add the Formula Column

1. Click the “+” sign to the right of your columns.
2. Search for and select “Formula”.
3. The formula editor will open.

---

✏️ How to Write a Formula

Step 1: Open the Formula Editor

Click on any cell in the Formula Column → Enter your formula in the editor.

Step 2: Reference Columns

• Use curly braces { } to refer to column names.
  Example: {Quantity} * {Price}

Step 3: Use Functions

Some popular functions include:

Function	Description	Example
IF(condition, true, false)	Conditional logic	IF({Status}="Done", "✔", "❌")
ROUND(value, decimals)	Rounds a number	ROUND({Hours}, 2)
DAYS(end, start)	Days between dates	DAYS({End}, {Start})
TODAY()	Current date	DAYS({Due Date}, TODAY())
CONCATENATE(val1, val2)	Combine text	CONCATENATE({Name}, " - ", {Status})

📌 Column names are case-sensitive and must match exactly.

✅ Real-World Examples

1. Calculate Task Cost

{Hours Worked} * {Hourly Rate}

2. Display Time Remaining

DAYS({Deadline}, TODAY())

3. Mark Overdue Tasks

IF(TODAY() > {Deadline}, “Overdue”, “On Time”)

4. Score KPI

IF({Sales} >= 1000, “✔ Target Met”, “🔻 Below Target”)

⚙️ Formula Column Limitations

• Formula columns are read-only—you cannot edit the result manually.
• You cannot use formula results in automations or integrations directly.
• Cannot reference other boards or dashboards.

---

📚 Tips for Using Formulas

• Double-check your column names in { }
• Use Preview Mode to test formulas before applying them broadly
• Combine Text + Logic to create smart labels and badges
• Use ISBLANK() to handle empty fields and avoid errors

---

🧠 FAQ

Q: Can I reference subitems in a formula?
A: No, formulas currently only calculate using data from the same item row.

Q: Can I create conditional logic like “If A and B then…”?
A: Yes. Use logical operators:

IF(AND({A}=”Yes”, {B}=”No”), “Do X”, “Do Y”)

Q: Can I color-code formula results?
A: Not directly, but you can use conditional formatting or a mirrored status column for color indicators.

✅ Summary

Feature	Supported in
Basic math & logic	✅ All plans
Date functions	✅ All plans
Conditional formatting	⚠️ Manual workaround
Automation based on formula	❌ Not directly
Cross-board formula	❌ Not available