Display hyperlink in short form

[Tom_automated]

I have a column with the url for my Google sheets (ex: https://docs.google.com/spreadsheets/d/44alphanumbericID/edit#gid=0). The type is set as url and the link works fine. But the link is very long. How do I keep the hyperlink but only display it’s ID rather than the full link?

I created a virtual column with formula Mid([GSheet], 40,84) to extract the Google Sheet ID from the Google sheet link of form https://docs.google.com/spreadsheets/d/44alphanumbericID/edit#gid=0. But then it’s no longer a hyperlink?

[James_McFarlane]

Hi Tom,

You could create a virtual column with Hyperlink Function.

help.appsheet.com

HYPERLINK()

New hyperlink

[Tom_automated]

My data is in Google Sheets. If I manually format my columns with the formula
=HYPERLINK("https://docs.google.com/spreadsheets/d/gsheetID/edit?usp=drivesdk","gsheetID") am I correct that AppSheet does not transfer that formula over? I would still need to make a new virtual column to make the data into a hyperlink that AppSheet recognizes?

[Steve]

AppSheet cannot handle spreadsheet formulas that contain arbitrary data. The gsheetID would be an example of arbitrary data. For AppSheet’s use, better the column contain the gsheetID, then construct the hyperlink in AppSheet.