Skip to main content
Question

Formula to show status for inbtween number range

  • February 5, 2019
  • 0 replies
  • 202 views
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 Shipping]>92,"<img src=\"https://www.quickbase.com/up/bcgnn27bx/g/rdc/eh/va/221-point_red.png\">";,
If([On Time Shipping]>=98 & <=93,"<img src=\"https://www.quickbase.com/up/bcgnn27bx/g/rde/eh/va/223-point_yellow.png\">")))

Really ideally I would like the actual number to change color instead of just the ball showing up but I will take what I can get.

Any help on the last piece there?

      This topic has been closed for replies.

      • DavidBrogdon
      • Quickbase Alumni
      • February 5, 2019
      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>" )

      • CeceliaMartin
      • Author
      • Quickbase Alumni
      • February 5, 2019
      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>" )))
      Terms & ConditionsAccessibility statement