Discussions

 View Only
  • 1.  Duration formula plus an icon

    Posted 10-30-2018 20:53
    I have a field that calculates today - another date. I want to use a red icon to "flag" if the other date is before today. I'm using Today()- Renewal Date to calculate if the renewal date has passed. I can't find a solution anywhere with any type of formula field.


  • 2.  RE: Duration formula plus an icon

    Posted 10-30-2018 20:57


  • 3.  RE: Duration formula plus an icon

    Posted 10-30-2018 21:02
    Hi Steve

    I have a video that shows how to use a Rich Text Formula field to include icons in your fields.

    You'll just need to set it up using an If instead of Case formula. Something like this:

    If([Renwal Date]<Today(),"<img src=\"https://images.quickbase.com/si/24/233-rhomb_red.png\">","")

    -Sharon




  • 4.  RE: Duration formula plus an icon

    Posted 10-30-2018 21:24
    The first option worked like a champ. I don't know what I did wrong as I tried several variations of that formula, including those shown in the video, but nothing worked until now. Thanks again.