Pretty url with url text output

Hi there, new to Make and not really a developer.

I’m exporting data from a task in ClickUp to a Google Sheet and one of the things im exporting is a link.

I’ve tried to find a way to make into a pretty link with text like this during the export.


There must be a simple way to do this that I’m missing.

Thanks in advance!

what is an example of UGLY URL that and a pretty URL?

Is it something like : Ugly → pretty.

Could you actually type it? It will help the understand the issue more.


How I want it to look (example):

So like this: LINK

Hey @TonkTonk,

You can use the formula =HYPERLINK("", "OOH flödesschema")
to achieve this result.

Hope this was helpful!


Big thanks! Super simple!

It worked! Another related question:
How would I go about adding ALL attachments from the input?

This is what worked:
=HYPERLINK(“{{1.custom_fields.Reklamationsunderlag.url}}”, “{{1.custom_fields.Reklamationsunderlag.title}}”)

The attachments are part of an array and I want all array items or 1, 2, 3, 4. Is there any way this can be done simply? I’ve made a separate post about this.