function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Using a double-quotes in a formula field


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.
I came across this this post today as I had a similar problem (to create a hyperlink formula in Excel), but ended up figuring it out.

Here is my solution based on your problem above: 
IF( ISBLANK( Website ), 
'<a href="' & Website & '">' & Name & '</a>')