Help with URL or Hyperlink

[Jaros]

I want to try and link a field to a Google doc.

I selected the field URL and added as an example,

Not the real links…

HYPERLINK(“https://docs.google.com/doc/d/1lr9LKXlHncVYqbHhUNvIRVEHpoOEw2shmttUeHq4huU/edit?usp=sharing","HOW TO CLEAN”)

I got the Hyperlink from using the sharing option and have set the sharing option to anyone can view.

This then gives me 2 fields one containing the URL and another one containing “HOW TO CLEAN”.

I thought it would give me a “HOW TO CLEAN” field that the user could click on.

UPDATE:

I think that the special characters in the google docs link would stop it from working so I did this.

HYPERLINK(CONCATENATE(“https://docs.google.com/doc/d/1lr9LKXlHncVYqbHhUNvIRVEHpoOEw2shmttUeHq4huU/edit?usp=",“sharing”),"HO... TO CLEAN”)

But it didn’t fix the problem so I attempted this.

HYPERLINK(
CONCATENATE(
“https://docs.google.com/doc/d/1lr9LKXlHncVYqbHhUNvIRVEHpoOEw2shmttUeHq4huU/edit?usp=”,
ENCODEURL(“sharing”)
),
“HOW TO CLEAN”)

Now I am out of ideas…

[Steve]

You haven’t explained how it doesn’t work. Where and how are you using this hyperlink?

[Jaros]

It just shows a greyed out field with the url link therein. I can’t do anything with the field.

I want to be able to click on the link, which is called “HOW TO CLEAN” and be directed to the Google doc.

[Steve]

Jaros:

It just shows a greyed out field with the url link therein. I

Where? Please post a screenshot.