Adding a field's value to a rich text formula

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
I need help with writing a rich text formula. 

I want to say:

if [field A] is not  "yes", show the field's value in #color, if not, show [field A]'s value.

So far I have:



If(

[field A]<> "yes", "<div style=\"background-color:#DADCBD;\"> [field A]- </div>",


[field A])





But for some reason, it's not working. Any ideas on how to get QB to recognize my field's value in the formula?
Photo of Ashley Asante

Ashley Asante

  • 696 Points 500 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb