Google Sheets has a formula called Hyperlink.
HYPERLINK(url, [link_label])
Example
HYPERLINK(“http://www.google.com/”, “Google”)
Where url is The full URL of the link location enclosed in quotation marks, or a reference to a cell containing such a URL.
and link_label - [optional] is the text to display in the cell as the link, enclosed in quotation marks, or a reference to a cell containing such a label.
It would be helpful if airtable could do this too.
My use case: Zapier finds new google docs in a special folder and adds records to an airtable which includes TITLE and URL. I have a view of that table that is embedded on my internal google site so that all new content in that folder (medical protocols) are available to my staff. It would be quite nice to have one field (a clickable link) rather than two - the title and an ugly url.
Please like this post to help it raise to the top!
... View more