Hi every one,
I try to make a hyperlink to google search which search the value of couple of cells from same row in google.
it is working fine on google sheet and here is the format:
=if(Isblank(A5)," ",HYPERLINK("https://www.google.com/search?hl=en&q="&A5&" “&E5&” "&G5,“Google Search”))
but when i click on appsheet link it give me [http://google%20search/]
the column property is follow:
Type = Url LaunchExternal = ture IsHyperlink = ture Read-Only Required Searchable Spreadsheet formula = if(Isblank(RC[-7])," ",HYPERLINK("https://www.google.com/search?hl=en&q="&RC[-7]&" “&RC[-3]&” "&RC[-1],“Google Search”))
What I have done wrong?
your help is much appreciated.