Add"$" to rich text field

Question

I am looking to add a "$" to a rich text field as I am actually color coding a numeric field. I have the formula below

If( [Field 1] > 1,
"<span style='background-color: #ffb3b3'>" & Round ([Field 1]),
ToText (Round(([Field 1]))))

------------------------------
D
------------------------------

markshnier__you · Answer

try thisIf( [Field 1] &gt; 1,"&lt;span style='background-color: #ffb3b3'&gt;" &amp; "$" &amp; ToText(Round ([Field 1])),"$" &amp; ToText (Round(([Field 1]))))------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

del · Answer

Works, thank you!------------------------------Ermias Bean------------------------------

del · Answer

Also need to add commas to the numbers. And is there a way to add a running totals column?------------------------------Ermias Bean------------------------------

donlarson · Answer

Ernias,Can you give an example of the underlying data and how that would be used in a running total?Don------------------------------Don LarsonPaasporterWestlake OH------------------------------

markshnier__you · Answer

try thisvar text RawText =&nbsp;"$" &amp; ToFormattedText(Round([Field 1]),"comma_dot",3);If( [Field 1] &gt; 1,"&lt;span style='background-color: #ffb3b3'&gt;" &amp; $RawText,$RawText)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Add"$" to rich text field

Related Content

Rich-text formula button on dashboard

"save and keep working" rich text button working in add but not edit form

Rich Text Button with rounded edge

Parse Through Rich Text Field

Rich text field html whitelist