I have a GSheet with a column that has human-readable text (not a URL) that has a hyperlink added. When I use the column as a data source, I only get the text. How can I also get the URL? Can I get the text in one column, and the URL in another, virtual column?

Extract URL from Google spreadsheet

LeventK June 30, 2020, 9:09pm 2

Is that column contain a HYPELINK/HYPERTEXT spreadsheet function?

Topic		Replies	Views
Display hyperlink in short form AppSheet Q&A databases	3	5	October 29, 2020
URL from google sheet AppSheet Q&A databases	1	1	March 12, 2023
URL & Text AppSheet Q&A expressions	7	8	January 25, 2022