Hi,

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.
Kim