If statement for url display name

[davyqliks]

Hi,

I am displaying a url in a table using the representation 'URL' and want a abel for if there is or is not a link in the data.

I tried the following, but all appear blank

I want to say 'View' if there is a value in the field PDF LINK and No Certificate if the field is empty

this is my effort.

=if(len([PDF link]>0)='View',
'No Cert'
)

but as mentioned, i get blank or greyed out.

thanks

DQ

[GaryGiles · Accepted solution]

@davyqliks 

First off, you need a ) after the link function, not the 0:

=if(len([PDF link])>0,'View',
'No Cert'
)

[davyqliks]

Hi,

Thanks... i was so close.

Really appreciate your time and assistance.

Thanks

DQ