I have created formula to create a url using the information from one cell "B2"
=CONCATENATE("http://mysite/Logs/",B2,"logs.htm")
This works to create the following:
http://mysite/Logs/namelogs.htm
The problem is when you hover on the link in the field or click it it wants
to go to the formula or
http://mysite/Logs/",B2,"logs.htm
How can I fix this?