Functions Utility Copy page Copy as markdownThe page as text, ready for a chat View as markdown/docs/functions/utility-functions.md Ask Claude about this pageOpens Claude with this page's address Helpers that do not belong to one calculation domain. FunctionWhat it does FROMBYTES Converts byte array to integer. GENERATEID Generates unique ID with prefix and random suffix. HASH Hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321). IMAGE Shows an image from a url: the browser loads it, the engine does not fetch. ISIN Checks if value is in a range or comma-separated list. RANDOMCHOICE Random pick from a range (with replacement); count > 1 spills a column. RANDOMINT.UNIQUE Generates unique random integers in range. RANDOMNORMAL Generates random values from normal distribution. SPARKLINE Draws a mini line or bar chart from a range: options take charttype, color, negcolor, linewidth, ymin and ymax. TIMESTAMP Current timestamp in milliseconds since epoch. TO_DATE Reads a number as a date serial. TO_DOLLARS Reads a number as a currency amount. TO_PERCENT Reads a number as a percentage. TO_PURE_NUMBER Strips formatting and returns the underlying number. TO_TEXT Converts a value to text. TOARRAY Materializes a range as a dynamic array (spills). TOBOOL Converts value to boolean. TODATE Parses text (YYYY-M-D, YYYY/M/D, M/D/YYYY, D.M.YYYY) to a date serial. TONUMBER Converts value to number; unparseable text returns default when given, else #VALUE! TOTEXT Converts value to text representation. TOTIME Parses \"HH:MM\" or \"HH:MM:SS\" text to a time fraction of day. UUID Generates UUID v4 string. VALIDATE.DATE Validates date components form valid date. VALIDATE.EMAIL Validates email address format. VALIDATE.PHONE Validates phone number format. VALIDATE.RANGE Validates value is within min and max range. VALIDATE.URL Validates URL format.
