ContributionsMost RecentMost LikesSolutionsRe: Formula Text field loses formatting of referenced fieldThanks for the help!Re: Formula Text field loses formatting of referenced fieldHah! If there was a string replace I could swap the carriage return for an html break but I haven't seen a solution for that so far. Can JavaScript be used in a formula field?Re: Formula Text field loses formatting of referenced fieldExactly, along with all white space being truncated to a single space. It seems like it's just dumping it out as text and treating the entire field as HTML.Re: Formula Text field loses formatting of referenced fieldUpdated OPFormula Text field loses formatting of referenced fieldI have a formula text field with HTML enabled that is just doing an If statement and then choosing between 2 existing text fields for its data. What's happening is when the formula text field is displayed, the formatting is lost. I believe what's happening is that it's treating the referenced field as pure text. I couldn't find a function that would preserve the formatting to HTML. Suggestions? Edit: Example text field: Hello How are you today? Results: Hello How are you today? Formula Text Field: if(Trim([Field1])="","<span style=\"color:red;\">"&[Field2]&"</span>",[Field1])