monday.com App · v1.0.0 · Coming soon
Formula Plus
The formula functions monday is missing — IFERROR, IFNA, COALESCE — writing into a real column.
- IFERROR / IFNA
- Writes to a column
- No eval — safe parser
- 30+ functions
The gap it closes
monday’s formula column is missing the functions that make spreadsheets survivable — IFERROR, IFNA, COALESCE, EMPTY — so a single divide-by-zero or missing value poisons the whole cell.
And it still cannot write its result anywhere, so even a correct formula is a dead end.
Formula Plus does both: a real expression language with error handling, and a result that lands in a genuine column.
How it works
Three steps, then it runs itself.
- 01
Write an expression against your columns
Reference columns by name —
IFERROR({Done} / {Total} * 100, 0)— with arithmetic, comparisons, text and logic. - 02
Handle the empty and broken cases
IFERROR catches division by zero. IFNA catches a missing column. COALESCE picks the first value that exists. Errors propagate exactly like a spreadsheet, so your fallback actually fires.
- 03
The answer lands in a real column
Point it at a Number, Text, Status, Date, Checkbox or Rating column — and everything downstream can act on it.
How it behaves
The decisions that matter.
-
Your expressions are never executed as code
The engine is a hand-written parser with a closed set of operators and whitelisted functions. It does not use eval or new Function, so an expression cannot reach the server runtime. There is no property access and no globals.
-
Errors propagate like a spreadsheet
If any operand is unavailable, the result is unavailable — which is what lets IFNA and IFERROR catch it. Silently degrading to null would make the fallback never fire.
-
Division by zero is catchable, not infinite
It returns an error value that IFERROR can trap, rather than an Infinity that quietly poisons the column.
-
Runaway expressions are bounded
Length and complexity limits mean a pathological formula cannot hang the app.
Pricing
Free tier that actually works.
Billed per account through monday.com's built-in monetization — not per seat. The free tier is deliberately functional so the app can prove itself on a real board before you pay for it. Trials get full Pro.
Free
$0
Basic
$15/mo
Standard
$35/mo
Pro
$70/mo
Documentation & data handling
Everything it touches, stated plainly.
Installing & getting started
- Install Formula Plus into your monday.com account and approve the permissions listed below.
- Open the board you want it on and add the app’s Automation block.
- Follow the three steps above. The free tier covers 1 formula — fully functional, on one board, so you can prove it works before paying.
- Stuck? Email support@buildsbyluke.com — two business days response.
Permissions, and why each one
me:read- Identify the installing account.
boards:read- Read the item’s column values to evaluate the expression against them.
boards:write- Write the computed result into the destination column — the core function of the app.
What is stored, and where
- The app stores no board data. Column values are read, evaluated in memory, written back, and discarded within the request.
- Expressions are stored as part of your automation configuration inside monday.
- The app runs entirely on monday code — monday.com’s own infrastructure. There is no external database.
Technical detail
- Version
- 1.0.0
- Hosting
- monday code (hosted on monday.com infrastructure)
- Runtime
- Node.js 18
- Authentication
- OAuth 2.0 + per-request JWT verification
- monday surfaces
- Automation block
- App ID
11809980- Support
- support@buildsbyluke.com
- Support SLA
- Two business days
- Publisher
- Builds By Luke, Canada
Questions people ask.
Is running my formula on your server safe?
The parser is purpose-built and closed. It has no access to the runtime, no globals and no property access — an expression can only do arithmetic, text and the listed functions.
What functions are available?
IF, IFERROR, IFNA, COALESCE, EMPTY, AND, OR, NOT, ROUND, ABS, FLOOR, CEIL, MIN, MAX, SUM, AVERAGE, CONCAT, UPPER, LOWER, TRIM, LEN, LEFT, RIGHT, CONTAINS and more.
What happens if a referenced column does not exist?
You get an unavailable value, which IFNA can catch and replace with a default.
Formula Plus is on its way.
It is built and running — currently going through monday.com’s marketplace review. Want a look before it lands?