Guide

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

Formula debuggerSee every step of a calculation.Formula ideasReady-made formulas to copy.SupportOpen a ticket.

Getting started4

Formulas13

Referring to columns in a formulaInsert columns with the column button; typed references like {item's Status} or {pulse.Status} don't work.Read Formula basicsHow a General Caster formula is written: values, operators, conditions, errors, text and numbers, and the step-by-step style.Read TextsJoin, cut, search, replace, clean and format texts; read a field from a long text; regular expressions.Read Numbers and totalsArithmetic and rounding; totals, averages and counts of several values; totals of subitems and mirror columns; running totals; shares of a group or a board.Read DatesHow 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; working hours and SLA deadlines; formats in your language.Read Lists and tablesColumns with several values as lists: split, count, filter, sort, look up, calculate on every item, join; tables of items with their columns.Read monday items, people and boardsWhat each column type gives the formula; the item itself; connected items, subitems and mirrors; people and teams, also by email or name; items of another board by a column's value (lookups, connecting items); every item of the group or the board; keeping every item up to date.Read Converting currenciesCURRENCY.CONVERT converts an amount from one currency to another at the latest daily rate; the currency block does it from one column to another.Read Places and distancesComing soon: how far a customer is, which technician or warehouse is closest, whether an address is inside your area: distances between Location columns, written into real columns.Read Data checksComing soon: check VAT numbers on VIES, IBANs, Italian tax codes, phones and emails, write phones in the international format, find duplicates on the board.Read AIComing soon: the AI reads a text and gives its kind, a detail written in words, a summary, a translation or its mood, written into a real column.Read Functions of the monday Formula columnADD_DAYS, FORMAT_DATE, HOURS_DIFF, WORKDAYS, MINUS and the other Formula column functions work in General Caster too, plus regular expressions.Read All functionsEvery function General Caster knows, by topic, with the page that explains it.Read

Errors6

Recipes4

Plans and credits2

Privacy and security1

Partners1