Guide
Everything about General Caster: setting it up, writing formulas, understanding errors, plans and privacy.
31 articles
Formula debuggerSee every step of a calculation.Formula ideasReady-made formulas to copy.SupportOpen a ticket.
Getting started4
How General Caster worksInstall the app, add an automation to a board and choose the formula and the column that receives the result.Read 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.Read Frequently asked questionsQuick answers about plans and billing, using General Caster and the most common problems.Read Emails from General CasterWhich emails we send, who receives them, and how to stop product news.Read
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
Wrong value (#VALUE!)A value of the wrong type was used, most often an empty column or text in a calculation.Read TroubleshootingWhat to check when a recipe doesn't do what you expect, and what each General Caster message means.Read Unknown name (#NAME?)The formula uses a function that doesn't exist or a column reference that was typed by hand.Read The target column doesn't existThe column chosen to receive the result was deleted; choose it again in the automation.Read 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.Read 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".Read
Recipes4
Barcodes and QR codesGenerate a barcode or a QR code from a formula and upload it to a File column or to the item's updates.Read 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.Read Auto-incrementChange a Numbers column by a fixed amount each time a status changes: counters, stock, scores, attempts.Read Addresses into a Location columnComing soon: the Text to Location automation block and the GEO.LOCATION function turn an address into a position in a Location column.Read
Plans and credits2
Privacy and security1
Partners1
No articles found for “”
Check the spelling or try another word. If the guide doesn't cover it, ask us: we answer and may add it.