function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ksnyderksnyder 

Using a double-quotes in a formula field

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
annenuguidannenuguid
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 ), 
Name,
'<a href="' & Website & '">' & Name & '</a>')

References: