
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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."
)
)
  
