TIMESTAMP

current timestamp in milliseconds since epoch · a deepcalc original · no excel equivalent · no sheets equivalent

signature

TIMESTAMP()

returns: number · volatile — recomputes on every evaluation

usage

  • =TIMESTAMP()

related

  • 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