CONCAT_URL ()

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.

Formula

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.

See the tips.

Example

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.