Skip to main content
Question

Duration formula plus an icon

Forum|alt.badge.img+7
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.
    This topic has been closed for replies.

    The easy icons are here.  502 icons in 5 convenient sizes

    https://login.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=160

    or here

    https://login.quickbase.com/db/bcgnn27bx?a=q&qid=1000039


    IF([date] < today(),   "<img src=https://images.quickbase.com/si/16/239-triang_red.png>")
    QuickBaseJunkie
    Forum|alt.badge.img+15
    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


    Forum|alt.badge.img+7
    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.
    Terms & ConditionsAccessibility statement