• annenuguid
  • 0 Points
  • Member since 2023

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 1

I am working on a formula field that would actually be generated as a report and pasted into HTML.

Basically, the scenario is this - if the Account, ABC Org has a value in Website, then I want it to display: ABC Org

If there is no website, then I just want it to display: ABC Org

So, I thought a formula field would work nicely for this:

IF(ISNULL( Website ) , Name + "
", "a href="" + Website + "">" + Name + "

But then I learned that formula fields do not want to display double-quotes. It keeps looking for my close parentheses after the double-set of quotes.

It didn't seem to want to display double-quotation marks under any circumstances.

Is there a workaround for this?

Many thanks.