Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 12, 2024 02:20 PM - edited Sep 12, 2024 02:22 PM
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!
Sep 12, 2024 04:57 PM - edited Sep 12, 2024 05:02 PM
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
Sep 12, 2024 05:18 PM
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."
)
)