New: Formula+ column

A monday.com formula column that saves its results

monday.com's formula column calculates on screen but never stores the result, so automations, Timeline and Gantt views, filters and dashboards can't use it. Formula+ is a column from Community Cookbook that runs Excel-style formulas and saves each result into a real monday.com column (a date, timeline, number, status, dropdown, checkbox, text, link, email or rating) and recalculates within seconds whenever an input changes.

Formula+ complete tour: everything a saving formula column can do · 10:01
Formula+ in under four minutes · 3:39

What's included

Custom Column

Formula+

Write a formula, choose what the result acts like, and pick the column it's saved in.

  • Results are saved, so automations, filters, search, dashboards, Timeline and Gantt can use them
  • Acts like a date, timeline, number, status, dropdown, checkbox, text, long text, link, email or rating
  • Recalculates by itself within seconds when an input changes
  • New items are calculated as soon as they're created, by hand, form or integration
  • Creates the result column for you, or saves into one you already have
  • Loop-safe: it never sets itself off
Formula language

Excel-style functions

Use the function names you already know, with a live preview on your own items.

  • Logic: IF, IFS, SWITCH, AND, OR, NOT, IFERROR
  • Maths: ROUND, ROUNDUP, SUM, AVERAGE, MEDIAN, MIN, MAX, MOD, POWER
  • Text: CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, FIND, SUBSTITUTE, UPPER, PROPER, and & to join
  • Dates: TODAY, DATE, EDATE, EOMONTH, DATEDIF, WEEKDAY, WEEKNUM, FORMAT_DATE
  • Plain-English errors before you save, like "Unknown function WORKDAI()"
Working days

Holiday-aware date maths

Count and add working days that skip weekends, public holidays and your company days off.

  • WORKDAY / ADD_WORKDAYS: a date plus or minus N working days
  • NETWORKDAYS / WORKDAYS: working days between two dates
  • IS_WORKDAY, NEXT_WORKDAY, PREV_WORKDAY
  • TIMELINE(start, end) saves straight into a Timeline column
  • Public holidays by country, custom weekends and your own closure days

How to use a formula in a monday.com automation

  1. 1

    Install Community Cookbook

    Add Community Cookbook from the monday.com marketplace. It's $10/month per workspace, not per seat.

  2. 2

    Add a Formula+ column

    On your board, add a column, open Installed Apps in the column center and add Formula+.

  3. 3

    Write the formula

    Open the column's settings to open the formula editor. Write an Excel-style formula, using {Column name} for your columns, and check the live preview.

  4. 4

    Choose what it acts like and where it's saved

    Pick the result type (for example Status, Date or Timeline) and an existing column, or let Formula+ create a new one. Save, and every item is calculated.

  5. 5

    Use the result in an automation

    Build a normal monday.com automation on the result column, for example "When Urgency changes to Urgent, move item to group". It runs whenever Formula+ updates the value.

Frequently asked questions

Can I use a formula column in a monday.com automation?
Not with monday.com's own formula column, because its result is never saved. Formula+ saves each result into a real column, so any monday.com automation that works on that column type works on the formula result.
Can a formula set a Timeline or date column in monday.com?
Yes. Choose Timeline or Date as the result type. For example TIMELINE(WORKDAY({Launch date}, -{Days before}), WORKDAY({Launch date}, -{Days before} + {Duration})) gives every task a working-day schedule that shows in monday.com's Timeline and Gantt views.
Can a formula set a status?
Yes. Choose Status as the result type and return a label, for example IFS({Days before} <= 10, "Urgent", {Days before} <= 25, "Coming up", TRUE, "On track"). Status changes then trigger automations like any other status.
How quickly does it recalculate?
Usually within 5 to 10 seconds of an input changing. New items are calculated when they're created, and you can recalculate any item from its cell.
Does it replace monday.com's formula column?
It sits alongside it. Keep monday.com's formula column for on-screen maths, and use Formula+ whenever the result needs to be saved and used elsewhere.
How much does it cost?
Community Cookbook is $10/month per workspace, not per seat. Formula+ and every other recipe are included.

Related: Working days & holidays · Recurring tasks · All views · Pricing

One price for your whole team

Community Cookbook is $10/month per workspace, not per seat. Every recipe, view and column is included, along with everything we add next.

Get the App