In a formula column, the CONCAT_URL function combines the content of several columns and turns it into a clickable URL link, to format a dynamic URL.
Always check the path of the URL you build. If a concatenated column is empty, a clickable link is still generated, but it points to an invalid URL (404 error).
Syntax
You can concatenate as many columns as you want, and insert free text anywhere, as many times as needed.
CONCAT_URL("start_of_my_url", Column2)
Examples
Format a URL
CONCAT_URL("https://www.pantone.com/color-of-the-year-", Year)
Result: the result becomes a clickable link, for example https://www.pantone.com/color-of-the-year-2018.
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- can still appear, but those URLs are not valid (404 error). Always make sure the URL path you build is correct and complete.
Create a link to Google Maps
You can create a clickable map link using:
CONCAT_URL("https://www.google.com/maps/place/", Address)
Example: with the address "5 avenue de Colmar, Rueil-Malmaison".
You can display a Google Maps preview in form mode using CONCAT_URL("https://www.google.fr/maps/place/*", address).
Go further
URL_TRIGGER
Use a formatted URL to call a webhook from an action button.
Or continue with
Formula glossary
All available operators and functions, sorted by category.