Guide

Everything about General Caster: setting it up, writing formulas, understanding errors, plans and privacy.

Getting started

Formulas

Referring to columns in a formula

Insert columns with the column button; typed references like {item's Status} or {pulse.Status} don't work.

Formula basics

How a General Caster formula is written: values, operators, conditions, errors, text and numbers, and the step-by-step style.

Texts

Join, cut, search, replace, clean and format texts; read a field from a long text; regular expressions.

Numbers and totals

Arithmetic and rounding; totals, averages and counts of several values; totals of subitems and mirror columns; running totals; shares of a group or a board.

Dates

How dates reach the formula and how to write them back; dates in words (DATE.WHEN); adding, counting, start and end of periods; working days and public holidays by country; formats in your language.

Lists and tables

Columns with several values as lists: split, count, filter, sort, look up, calculate on every item, join; tables of items with their columns.

monday items, people and boards

What each column type gives the formula; the item itself; connected items, subitems and mirrors; people and teams; every item of the group or the board; keeping every item up to date.

Converting currencies

MONDAY.CURRENCY converts an amount from one currency to another at the latest daily rate; the currency block does it from one column to another.

Functions of the monday Formula column

ADD_DAYS, FORMAT_DATE, HOURS_DIFF, WORKDAYS, MINUS and the other Formula column functions work in General Caster too, plus regular expressions.

All functions

Every function General Caster knows, by topic, with the page that explains it.

Errors

Recipes

Plans and credits

Privacy and security

Partners