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.
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.