Hi Again, My (hopefully) last problem for now...

[Kayleigh_Seeley]

Hi Again, My (hopefully) last problem for now is I am wanting the PDF I am linking from Google Drive into the app to have the title of the document as the link, instead of the URL. Can anyone explain how I am supposed to do that?

[Aleksi_Alkio]

Have you tried to use the option IsHyperLink as TRUE?

[pravse]

What column type is ‘Tasks List’?

If it is a URL type, then the value should be a HYPERLINK(“Name”, “http://whatever…”)

If it is a File type, then it should be the file name relative to the spreadsheet — eg: Files/DataFile1.pdf

[Kayleigh_Seeley]

@Aleksi_Alkio I have tried to used the option IsHyperLInk as TRUE and it still is not displaying a name of the file but rather the url still.

[Kayleigh_Seeley]

@praveen The column type is URL and I still was not able to get it to work with the HYPERLINK(“title”, “url”)

[Kayleigh_Seeley]

Nevermind, I used the HYPERLINK(“title”, “url”) in my original google sheet and it worked. Thank you.