How to Calculate Values Using Formula Columns in monday.com
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
- Click the “+” sign to the right of your columns.
- Search for and select “Formula”.
- 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 |
