Guide
Everything about General Caster: setting it up, writing formulas, understanding errors, plans and privacy.
Getting started
Install the app, add an automation to a board and choose the formula and the column that receives the result.
Recipes and triggersEvery General Caster recipe, when it can run, which plan it needs, which columns it can write into, and how to write into a column of another board.
Frequently asked questionsQuick answers about plans and billing, using General Caster and the most common problems.
Emails from General CasterWhich emails we send, who receives them, and how to stop product news.
Formulas
Insert columns with the column button; typed references like {item's Status} or {pulse.Status} don't work.
Formula basicsHow a General Caster formula is written: values, operators, conditions, errors, text and numbers, and the step-by-step style.
TextsJoin, cut, search, replace, clean and format texts; read a field from a long text; regular expressions.
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.
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; formats in your language.
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.
monday items, people and boardsWhat 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 currenciesMONDAY.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 columnADD_DAYS, FORMAT_DATE, HOURS_DIFF, WORKDAYS, MINUS and the other Formula column functions work in General Caster too, plus regular expressions.
All functionsEvery function General Caster knows, by topic, with the page that explains it.
Errors
A value of the wrong type was used, most often an empty column or text in a calculation.
TroubleshootingWhat to check when a recipe doesn't do what you expect, and what each General Caster message means.
#NAME? in the resultThe formula uses a function that doesn't exist or a column reference that was typed by hand.
The target column doesn't existThe column chosen to receive the result was deleted; choose it again in the automation.
A column did not accept the valueEach column type expects its own format: dates as YYYY-MM-DD, timelines as two dates, statuses and dropdowns as existing labels.
Permissions and "not found" errorsGeneral Caster needs access to the workspaces of the boards it works on; deleted or moved items also cause "not found".
Recipes
Generate a barcode or a QR code from a formula and upload it to a File column or to the item's updates.
MapsTurn the position of a Location column into a map image with a pin, uploaded to a File column or to the item's updates.
Auto-incrementChange a Numbers column by a fixed amount each time a status changes: counters, stock, scores, attempts.