Formula Function Index
Browse AnyDB formula functions by category. Each card links to the detailed reference page for syntax, examples, and usage notes.
Function Categories
TextLENReturn the length of a text string.CONCATJoin text values into one string.TRIMRemove extra spaces from text.SEARCHFind a text string within another text string.LEFTReturn characters from the start of text.RIGHTReturn characters from the end of text.MIDReturn characters from the middle of text.REPLACEReplace part of a text string.SUBSTITUTEReplace matching text with new text.UPPERConvert text to uppercase.LOWERConvert text to lowercase.PROPERCapitalize words in text.TEXTFormat a value as text.REGEXTESTCheck whether text matches a regular expression.REGEXEXTRACTExtract text matching a regular expression.REGEXREPLACEReplace text matching a regular expression.
MathSUMAdd values in a range or array.MAXReturn the largest value.MINReturn the smallest value.MEANReturn the average value.POWERRaise a number to a power.ROUNDRound a number to a chosen precision.SQRTReturn the square root of a number.FLOORRound a number down.CEILINGRound a number up.PMTCalculate a loan payment.READABLEPERCENTFormat a percent value for display.
Date & TimeTODAYReturn the current date.FORMATDATEFormat a timestamp as a readable date.DATEVALUEConvert text into a date value.DAYSReturn days between two dates.DAYReturn the day of the month.MONTHReturn the month from a date.YEARReturn the year from a date.HOURReturn the hour from a time.MINUTEReturn the minute from a time.SECONDReturn the second from a time.WEEKDAYReturn the day of week.WEEKNUMReturn the week number.WORKDAYAdd or subtract workdays.DATEADDAdd time to a date.DATESUBTRACTSubtract time from a date.DATEDIFCalculate date differences.DATECreate a date value.YEARFRACReturn the fraction of a year between dates.READABLEDATEFormat a date for display.READABLEDATETIMEFormat a date and time for display.
Logic & AggregationIFReturn a value based on a condition.IFERRORReturn a fallback value when a formula errors.COUNTCount numeric values.COUNTIFCount values matching one condition.COUNTIFSCount values matching multiple conditions.COUNTNIFCount values that do not match a condition.SUMIFSum values matching one condition.SUMIFSSum values matching multiple conditions.MINIFReturn the minimum value matching one condition.GROUPBYSUMGroup objects and sum numeric values.INGROUPCheck whether a value belongs to a group.NOTINGROUPCheck whether a value does not belong to a group.INCONTEXTCheck whether a lock is evaluated in a specific context.NOTINCONTEXTCheck whether a lock is evaluated outside a specific context.
Arrays & LookupsFILTERFilter data by criteria.FILTERYEARFilter arrays or objects by year.MAPExtract values from arrays of objects.MAXBYReturn the max value by criteria.MINBYReturn the min value by criteria.SUMBYSum a property in an array of objects.SORTBYSort an array of objects by a property.FLATTENCombine an array of arrays into one array.THRESHOLDBYSUMFind where a running sum crosses a threshold.HTABLEGenerate an HTML table from packed data.DYNREFRead a value from a referenced record.VLOOKUPLook up a value in a table.
ValidationISEMAILValidate an email address.ISPHONEValidate a phone number.ISALPHANUMERICCheck whether text is alphanumeric.ISNUMERICCheck whether a value is numeric.ISURLValidate a URL.ISIPValidate an IP address.ISMACADDRESSValidate a MAC address.ISCREDITCARDValidate a credit card number.ISPASSPORTNUMBERValidate a passport number.ISPOSTALCODEValidate a postal code.ISODATECheck whether text is a valid ISO date.ISMONTHCheck whether a date is in a month.ISYEARCheck whether a date is in a year.
GeographicCONTINENTSReturn continents for a location.COUNTRIESReturn countries for a location.STATESReturn states for a location.LANGUAGESReturn languages for a location.