Hyperlink in Google Sheet for Lookerstudio also

[StefanWM]

Hi there,

I am having a Google Sheet as a source for Lookerstudio. In one column there is the text "Document" which is a hyperlink like that  =HYPERLINK("https://drive.google.com/..."; "Document"). I want to show this in a Lookerstudio table column also. Can I get this with an own calculate field? Or is this hyperlink gone and not able for Lookerstudio to get it?

[阿泰]

I think you can create a new column by copying data from your original column and applying a formula. See the reference below:
(Column A simulates your original column, and column B is the copied version with the applied formula.)

Once you've completed the above steps, simply import the Google Sheet and set column B's type to "URL." This will make the links clickable and direct users to the respective websites.