CRYPTO.HASH
Creates an hash value for given text. The used hash algorithm can be optionally specified. For a list of supported hash algorithms please refer to Hash Algorithms. The used hash algorithms are from the OpenSSL Library. See their docs for more details.
Syntax
=CRYPTO.HASH(Text, [Algorithm])
Arguments
Name | Type | Description |
---|---|---|
Text | String | A text to create hash value for. |
Algorithm (optional) | String | The hash algorithm to use. Defaults to "sha256" |
Return
The hash value or an Error Code
Examples
Formula | Result | Comment |
---|---|---|
| 2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824 | By default "sha256" is used. |
| 5d41402abc4b2a76b9719d911017c592 | Same text as before but creates an hash using "md5" algorithm. |