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.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.
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.GROUPBYSUMGroup objects and sum numeric values.INGROUPCheck whether a value belongs to a group.NOTINGROUPCheck whether a value does not belong to a group.
Arrays & LookupsFILTERFilter data by criteria.FILTERYEARFilter arrays or objects by year.MAPExtract values from arrays of objects.MAXBYReturn the max value by criteria.SUMBYSum a property in an array of objects.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.