In a column of type formula, the CONCAT_URL() function allows to concatenate the content of a column by transforming it into a clickable url link.
I can concatenate as many columns as I want.
I can place text where I want, as many times as I want.
The result of my formula becomes a clickable link: https://www.pantone.com/color-of-the-year-2018
In my formula column CONCAT_URL(), the clickable links do exist (https://www.pantone.com/color-of-the-year-), but this address does not exist (the page displays a 404 error).
You have to make sure that the path of the url you have built is valid.