Functions
HYPERLINK
Return link label (or url if no label)
When to use it
When should I use HYPERLINK?
Use HYPERLINK to create a clickable link in a cell, displaying a friendly label while pointing to a URL; in formula evaluation contexts it returns the label or URL string.
Used in
Syntax
HYPERLINK(url, [link_label])