CONCAT_URL()

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.

Formula

CONCAT_URL("start_of_my_url",Column2)

I can concatenate as many columns as I want.

I can place text where I want, as many times as I want.

Example

CONCAT_URL("https://www.pantone.com/color-of-the-year-",Year)

Configurator

Result

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.