Duration formula plus an icon

Question

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.

quickbasecoachd · Answer

The easy icons are here.&nbsp; 502 icons in 5 convenient sizeshttps://login.quickbase.com/db/9kaw8phg?a=ShowPage&amp;pageid=160or herehttps://login.quickbase.com/db/bcgnn27bx?a=q&amp;qid=1000039IF([date] &lt; today(),   "&lt;img src=https://images.quickbase.com/si/16/239-triang_red.png&gt;")

quickbasejunkie · Answer

Hi SteveI 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]&lt;Today(),"&lt;img src=\"https://images.quickbase.com/si/24/233-rhomb_red.png\"&gt;","")-Sharon

stevenpearson · Answer

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.

Forum Discussion

Duration formula plus an icon

Related Content

Create a formula duration over 5 years

Duration Formula

Formula Checkbox and Duration

Duration Fields with Pipelines

Delete Formula Button Error