deepcalc
DocsGENERATEID

GENERATEID

View as markdown/docs/functions/generateid.md Ask Claude about this pageOpens Claude with this page's address

Generates unique ID with prefix and random suffix.

  • Origin: A deepcalc original
  • Excel: No equivalent
  • Google Sheets: No equivalent
  • Returns: Text
  • Volatile: recomputes on every evaluation

Examples

  • =GENERATEID()
  • =GENERATEID("ID-", 12)

Syntax

GENERATEID([prefix], [length])
prefix
text optional
length
number optional

Errors

#VALUE!
=GENERATEID(A1:A3)
FROMBYTESConverts byte array to integer. HASHHex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321). IMAGEShows an image from a url: the browser loads it, the engine does not fetch. ISINChecks if value is in a range or comma-separated list. RANDOMCHOICERandom pick from a range (with replacement); count > 1 spills a column. RANDOMINT.UNIQUEGenerates unique random integers in range.