URL not appears as clickable, but as text

[areyes]

Hi Team, 

Could you please give me some ideas on how make my url clickable. 

I have on my report from google docs set like this

And my output is like this:

It appears as text. This happened after I set the ifblank function, and although I set the Linktext still is not working. 

The data type is set as URL.

[SkrOYC]

See if you have a Format Rule applied to that column

[areyes]

There is not format rule, in the sheet doc they are display as url indeed. 

[areyes]

I have also tried using HYPERLINK like this: 

<<IF(ISBLANK([URL]), “SIN ADJUNTO”, (HYPERLINK(“VER ADJUNTO”, [URL])))>><<End>>

But still is not showing the text as a clickable link

[SkrOYC]

Por favor comparte una captura de la configuración de la columna [URL]

[areyes]

I have nothing configured in the column, my config is in the template doc. 

Here is the config

Here is my template:

The idea is that when I add an URL, in my report there is a clickable link, but if I do not have an URL, the word "SIN ADJUNTOS" may be shown. 

Here is my output, the IF and ISBLANK is working fine, but the clickable link isn't working. 

[Suvrutt_Gurjar]

From the various screenshots shared by you, it sounds that your HYPELINK() expression needs revision. You have placed the link text " VER ADJUNTO" first before the [URL], the HYPELINK() function's syntax needs the text after the URL

HYPERLINK() - AppSheet Help

[areyes]

Thanks for your reply. Yes, yesterday I also realized of that, and although I change the order, still having the same output. 

[Suvrutt_Gurjar · Accepted solution]

Oh, okay. Please try,

<<IFS(ISBLANK ([URL]), "SIN ADJUNTO" )>>

<<IFS(ISNOTBLANK ([URL]), HYPERLI K([URL], "VER ADJUNTO" ))>>

Please insert both the above expressions in place of existing single expression under the heading ADJUNTOS

[areyes]

Thank you! It worked!

[Suvrutt_Gurjar]

You are welcome. Nice to know it works as per requirement. If I may mention, with IF() statement,  the hyperlink was getting converted to a text value because the first result of IF () was a text. Hence suggested to use IFS(), thereby separating the results of two different types- text and URL.

[areyes]

Understood!

[SkrOYC]

Also, for reference:

Use If expressions in templates - AppSheet Help

I think template IF are the best tool for the job when it comes to templates.

Considering @Suvrutt_Gurjar's reply, something like:

<<IF:ISBLANK([URL])>>SIN ADJUNTO<<EndIf>>

<<IF:ISNOTBLANK([URL])>><<HYPERLINK([URL], "VER ADJUNTO"))>><<EndIf>>