Forum Discussion

EricRovner's avatar
EricRovner
Qrew Member
4 years ago

Using Rich Text Formula Field to Display Icon

Hello! I would like to have an icon show up in a table if more than a year has elapsed since a defined date. I believe the correct approach is to use a Rich Text Formula field but I'm struggling a bit...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Try this
If(Today()-[Last Raise] > Days(365),  "<img src=https://images.quickbase.com/si/16/241-triang_yellow.png>")

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • EricRovner's avatar
    EricRovner
    Qrew Member
    4 years ago
    Worked like a charm - Thank You Mark! So appreciative of the timely and helpful answers.

    ------------------------------
    Eric Rovner
    ------------------------------