All functions
Every function General Caster knows, by topic, with the page that explains it.
Functions marked new work in the recipes created from November 2026 and in the new automation blocks; the others work in every recipe. The spreadsheet functions have the same names and arguments as in Excel and Google Sheets.
Logic — Formula basics
IF · IFS · SWITCH · CHOOSE · AND · OR · XOR · NOT · IFERROR · IFNA · NA · ERROR · ERROR.MESSAGE · ISBLANK · ISNUMBER · ISTEXT · ISERROR · TRUE · FALSE
Text — Texts
CONCAT · CONCATENATE · TEXTJOIN · LEFT · RIGHT · MID · LEN · FIND · SEARCH · SUBSTITUTE · REPLACE · TRIM · UPPER · LOWER · PROPER · REPT · EXACT · CHAR · UNICHAR · UNICODE · TEXT · FIXED · VALUE · BASE
new: TEXT.BEFORE · TEXT.AFTER · TEXT.FIELD · TEXT.LINES · TEXT.WORDS · TEXT.INITIALS · TEXTBEFORE · TEXTAFTER · REGEXEXTRACT · REGEXREPLACE · REGEXMATCH
Numbers and totals — Numbers and totals
ROUND · ROUNDUP · ROUNDDOWN · MROUND · CEILING · FLOOR · INT · ABS · MOD · POWER · SQRT · LOG · PI · RAND · RANDBETWEEN · SUM · SUMIF · SUMPRODUCT · PRODUCT · AVERAGE · AVERAGEIF · MEDIAN · MIN · MAX · COUNT · COUNTA · COUNTBLANK · COUNTIF
Several values in one column: MONDAY.NUMBER.SUM · MONDAY.NUMBER.AVG · MONDAY.NUMBER.MIN · MONDAY.NUMBER.MAX · MONDAY.GENERAL.COUNT · MONDAY.DATE.MIN · MONDAY.DATE.MAX · MONDAY.DATE.TIMELINE · MONDAY.DURATION.SUM · MONDAY.DURATION.AVG · MONDAY.DURATION.MIN · MONDAY.DURATION.MAX · MONDAY.TIMELINE.SUM (also as SUBITEMS.*, MIRROR.* and HELPER.*)
new: MONDAY.CURRENCY — see Converting currencies
Dates — Dates
TODAY · NOW · DATE · TIME · DATEVALUE · TIMEVALUE · YEAR · MONTH · DAY · HOUR · MINUTE · SECOND · WEEKDAY · WEEKNUM · ISOWEEKNUM · DAYS · DATEDIF · YEARFRAC · EDATE · EOMONTH · WORKDAY · NETWORKDAYS
new: DATE.WHEN · DATE.ADD · DATE.DIFF · DATE.START · DATE.END · DATE.NEXT_WORKDAY · DATE.WORKDAY_FROM · DATE.IS_WORKDAY · DATE.IS_WEEKEND · DATE.IS_HOLIDAY · DATE.HOLIDAY · DATE.FORMAT · DATE.WEEKDAY_NAME · DATE.MONTH_NAME · DATE.QUARTER · DATE.WEEK
Lists and tables — Lists and tables
new: LIST.SPLIT · LIST.JOIN · LIST.COUNT · LIST.FIRST · LIST.LAST · LIST.ITEM · LIST.SORT · LIST.UNIQUE · LIST.REVERSE · LIST.CONTAINS · LIST.POSITION · LIST.REMOVE · LIST.TAKE · LIST.SKIP · LIST.COMBINE · LIST.WHERE · LIST.EACH · LIST.LOOKUP · TABLE.COLUMN · TABLE.WHERE · TABLE.LOOKUP · TABLE.COUNT · MONDAY.LIST.FIRST · MONDAY.LIST.LAST · MONDAY.LIST.ITEM · MONDAY.LIST.UNIQUE
new, as in Excel 365: TEXTSPLIT · FILTER · SORT · SORTBY · UNIQUE · XLOOKUP · XMATCH · SEQUENCE · TAKE · DROP · CHOOSEROWS · CHOOSECOLS · VSTACK · HSTACK · TOCOL · TOROW · WRAPROWS · WRAPCOLS · TRANSPOSE · ROWS · COLUMNS · LET · LAMBDA · MAP · REDUCE · SCAN · BYROW · BYCOL · MAKEARRAY
Lookups in every recipe: VLOOKUP · INDIRECT · ROW
monday items, people and boards — monday items, people and boards
MONDAY.PEOPLE.EMAIL
new: MONDAY.ITEM.NAME · MONDAY.ITEM.COLUMN · MONDAY.ITEM.ID · MONDAY.ITEM.URL · MONDAY.ITEM.BOARD · MONDAY.ITEM.GROUP · MONDAY.ITEM.CREATED · MONDAY.ITEM.UPDATED · MONDAY.ITEM.CREATOR · MONDAY.ITEM.LAST_UPDATE · MONDAY.ITEMS · MONDAY.PERSON.NAME · MONDAY.PERSON.EMAIL · MONDAY.PERSON.PHONE · MONDAY.PERSON.MOBILE · MONDAY.PERSON.TITLE · MONDAY.PERSON.LOCATION · MONDAY.PERSON.TIMEZONE · MONDAY.PERSON.TEAMS · MONDAY.PERSON.PHOTO · MONDAY.PERSON.URL · MONDAY.TEAM.NAME · MONDAY.TEAM.MEMBERS · MONDAY.GROUP.COLUMN · MONDAY.GROUP.ITEMS · MONDAY.BOARD.COLUMN · MONDAY.BOARD.ITEMS
From the monday Formula column — Functions of the monday Formula column
new: MINUS · MULTIPLY · DIVIDE · ADD_DAYS · SUBTRACT_DAYS · ADD_MINUTES · SUBTRACT_MINUTES · FORMAT_DATE · HOURS_DIFF · WORKDAYS