Discussions

Expand all | Collapse all

Adding a field's value to a rich text formula

  • 1.  Adding a field's value to a rich text formula

    Posted 06-29-2018 19:53
    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?


  • 2.  RE: Adding a field's value to a rich text formula

    Posted 06-29-2018 19:57