Forum Discussion

CeceliaMartin's avatar
CeceliaMartin
Qrew Cadet
7 years ago

Formula to show status for inbtween number range

I would like to have a yellow status for anything between 98 & 93 If([On Time Shipping]<99,"<img src=\"https://www.quickbase.com/up/bcgnn27bx/g/rdd/eh/va/222-point_green.png\">";, If([On Time Ship...
CeceliaMartin's avatar
CeceliaMartin
Qrew Cadet
7 years ago
Close, but I am getting an error on the last line.  And when entering any other type of number the color does not change.

On Time Shipping % is a numeric field.
What I am creating is a rich text formula.  Is that correct?

If([On Time Shipping %]<99,"<span style='font-size: 15pt; text-align: left; color: green'>" & ToText([On Time Shipping %]) & "</span>",

If([On Time Shipping %]>92,"<span style='font-size: 15pt; text-align: left; color: red'>" & ToText([On Time Shipping %]) & "</span>",

If([On Time Shipping %]>=98&<=93,"<span style='font-size: 15pt; text-align: left; color: yellow'>" & ToText([On Time Shipping %]) & "</span>" )))
DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago
Yes, rich text formula field. You don't need to repeat the If statement after the first time. I forgot the " before the span on the second and third. Try this-->

If([On Time Shipping %]<99,"<span style='font-size: 15pt; text-align: left; color: green'>" & ToText([On Time Shipping]) & "</span>",

[On Time Shipping %]>92,"<span style='font-size: 15pt; text-align: left; color: red'>" & ToText([On Time Shipping]) & "</span>",

[On Time Shipping %]>=98 & <=93," <span style='font-size: 15pt; text-align: left; color: yellow'>" & ToText([On Time Shipping]) & "</span>" )