AshleyAsante
7 years agoQrew Cadet
Adding a field's value to a rich text formula
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?
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?