Forum Discussion

Qrew Captain

3 years ago

formula assistance - rich text w/date

[SAND DATE STATUS] IF THE DATE IN [SAND DATE] FIELD IS "before today", display red status button, otherwise display blue button. IF(ToText([SAND DATE])<(today)), "<img src=\"https://images.quickb...

Formulas and functions

Claudevon_Roesg

Qrew Member

Try

IF([SAND DATE]<today()),
"<img src=\"images.quickbase.com/si/24/204-warning.png\" title=\"delete\">",
"<img src=\"images.quickbase.com/si/16/224-point_blue.png\" title=\"TO DO\">")

------------------------------
Claude von Roesgen
------------------------------

Claudevon_Roesg

Qrew Member

3 years ago

Correction

IF([SAND DATE]<today(),
"<img src=\"images.quickbase.com/si/24/204-warning.png\" title=\"delete\">",
"<img src=\"images.quickbase.com/si/16/224-point_blue.png\" title=\"TO DO\">")

------------------------------
Claude von Roesgen
------------------------------