In a formula-type column, the CONCAT_URL() function allows you to concatenate the contents of a column and transform it into a clickable URL link.

🔤 Formula

CONCAT_URL("start_of_my_url", Column2)

You can concatenate as many columns as you want.
You can insert text wherever you want, as many times as you want.

🧪 Example

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

⚙️ Configurator

✅ Result

The result of this formula becomes a clickable link:
https://www.pantone.com/color-of-the-year-2018

Notes:
In this example, some values in the Year column are empty.
In the CONCAT_URL formula column, clickable links like
https://www.pantone.com/color-of-the-year-
still appear, but those URLs are invalid (404 error pages).

You must make sure that the constructed URL is valid.

🗺️ Bonus example with Google Maps

You can create a clickable map link using:

CONCAT_URL("https://www.google.com/maps/place/", Address)

Example:
5 avenue de Colmar, Rueil-Malmaison

🔁 Also see the article: URL_TRIGGER()

Let me know if you'd like me to turn this into an HTML version or embed specific links and images!

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.