Forum Discussion

LennyBrooks's avatar
LennyBrooks
Qrew Member
3 years ago

Help if Formula Rich Text

I'm trying to use an IF statement in a Formula Rich Text formula field in a report.  I want a yellow triangle to populate of a certain date is or before today.  Here is my formula, which seems fine un...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
It looks ok to me but try this variation.

If([Collections_Lien Review Date]<=Today(),"<img src=https:\\images.quickbase.com/si/16/241-triang_yellow.png>")

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------