Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to hyperlink text inside a formula?

Topic Labels: Formulas
293 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Paul_Matsushima
6 - Interface Innovator
6 - Interface Innovator

Hello,

I'd like my formula to spit out a paragraph of text. Some of the text within the formula, I'd like to include hyperlinks. Is this possible?

Here's an example:

If field A = option 1, spit out this text:

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

If field A = option 2, spit out this text:

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Again, my main question is: is it possible to hyperlink a piece of text in a formula?

Thank you!

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

I don't think this is currently possible I'm afraid.  You probably already know this, but as a workaround perhaps you could create a long text field with rich text formatting turned on and then use an automation to paste the formula output (with hyperlink via markdown) into that?  That way you'd have the text you want with the hyperlink

Sho
11 - Venus
11 - Venus

Hi @Paul_Matsushima,

How about using automation?
Writes the result of the formula field into a long text field.

IF(Option,
  SWITCH(Option,
    "1", "Lorem ipsum [dolor](https://google.com) sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.",
    "2", "[Lorem ipsum](https://google.com) dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua."
  )
)

スクリーンショット 2024-09-13 091434.png

スクリーンショット 2024-09-13 091513.png