This formula was used with a CorasWorks rollup to display a custom link that says “Click Here”. It does not appear to work as a link in list’s native view.

==================================

=IF(NameCTEcorp<>”",CONCATENATE(“<a target=new href=https://xxxxx.com/sites/sitename/”,NameCTEcorp,”>click here<br>to view</a>”),”")

Go to the main page