In a column of type formula, the CONCAT_URL () function is used to concatenate the contents of a column by transforming it into a clickable url link.
CONCAT_URL ( "début_de_mon_url" Column2)
I can concatenate as many columns as I want.
I can place text wherever I want, as many times as I want.
CONCAT_URL ( "https://www.pantone.com/color-of-the-year-" Year)
The result of my formula becomes a clickable link : https://www.pantone.com/color-of-the-year-2018
Notes : In this example, fields in the Year column are blank.
In my Formula CONCAT_URL column, clickable links exist (https://www.pantone.com/color-of-the-year-), but this address does not exist (the page displays a 404 error).
You must make sure that the url path you have built is valid.