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…