Embed hyperlink in Formula Rich Text field
Hi,
I have a rich text formula field with an IF function to display specific text when a criteria is met. I want to add a link to a file in between the text output that opens on a different window. I need the display text to show as a hyperlink.
Example: If ([Platform] = "A", "Complete all tasks assigned for 'Priority Sites' once every 2 months", "No action necessary for this year")
Where 'Priority Sites' is the display text for the SharePoint web link https://sharepoint/prioritysites.pdf
From what I could find online, I guess I have to create a hyperlink field to store the web address but I'm not too sure how that works. Can someone provide a step by step guide on how to achieve the desired output?
The generic syntax for a Rich Text Hyperlink is this:
"<a href=" & $URL & ">" & $Words & "</a>"
so if you had a URL type field to store the link you could do
var text Words = "PrioritySites";
var text URL = [My URL field];
var text Hyperlink = "<a href=" & $URL & ">" & $Words & "</a>";
If ([Platform] = "A", "Complete all tasks assigned for " & $Hyperlink & " once every 2 months", "No action necessary for this year")
