BBCode [URL used with formula

Can you constuct a BBCode [URL using a formula?
I want the link text to be Clcik Here but then the href like should be a value made using a formula.

I want this listed as a column in a list of records people can click on so an action button where you need to be inside the record.



Not quite sure that you mean but it’s supported to use string formulas to construct a BBCode. For example:
Note: A4 would the field that contains the link.

If this is not what you’re looking for, please share an actual example for us to refer to.

Thanks I tried that but it does not seem to work.


I found the problem, if A3 has spaces in it then the link will not work you have to use SUBSTITUTE(A3,' ', '%20')

Hope that helps someone else.