How to create name + hyperlink in a cell with bulk list?

[jameshere]

Is it possible to create one collumn that contains name with a hyperlink combined?

I know how to do it manually. Is there a way how to do it automatic?

I can easily do this in bulk on google sheets. But when trying to paste the data from sheets to airtable it just shows the name without the hyperlink.

How do I do this automatic?

[TheTimeSavingCo]

Use a formula field to format your hyperlinks into `[LINK TEXT](URL)`, for example, `[Google](www.google.com)`, and then use an automation to paste that value into a rich text field (a long text field with rich text enabled)

[jameshere]

Thank you for your answer.

I've two collumns.

"namecopy" and "Website"

If I understood you correctly I did what you said. And it won't merge.

"Namehttps://i.ibb.co/nR9r00G/image.png

[TheTimeSavingCo]

Ah, you need to reference the formula fields, so something like:

"[" & {namecopy} & "](" & {Website} & ")"

[jameshere]

Thanks!

Almost there. I used your formula and got this.

[TheTimeSavingCo]

You'll need to use an automation to paste that value of `[Google](www.google.com)` into a rich text field (a long text field with rich text enabled)