Skip to main content
Question

Using Rich Text Formula Field to Display Icon

  • April 21, 2022
  • 0 replies
  • 333 views

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 to construct the correct formula.

The defined date is "Last Raise" and I'd like a warning icon to show when today's date is 365 days or more after that date.

Here's my draft Rich Text formula (that doesn't work!) - I know it's because I'm mixing operators but I just can't figure out the solution. Thanks in advance for the assist!

If(Today()-[Last Raise]>365,"<img src=https://images.quickbase.com/si/16/241-triang_yellow.png>")

------------------------------
Eric Rovner
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • April 21, 2022
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
------------------------------