Forum Discussion

LisaMarie1981's avatar
LisaMarie1981
Brass Contributor
Jul 06, 2022

Icons based on percentage not working

I am trying to have anything that is =>100% show as green check mark icon, anything above 50% show as yellow ! icon and anything 50% or < to show as red x icon, but for some reason it's not working. It's as if it's taking into consideration the percentage from the previous cell? See attached. Hoping someone can help!! 

I've tried this but doesn't work

 

 

  • Hi Lisa,
    have you tried using the following?
    Value = 1, Type = Value
    Value = 0.5, Type = Value
  • _MartinB's avatar
    _MartinB
    Iron Contributor
    Hi Lisa,
    have you tried using the following?
    Value = 1, Type = Value
    Value = 0.5, Type = Value
    • LisaMarie1981's avatar
      LisaMarie1981
      Brass Contributor
      Man I feel like an idiot now, that never even crossed my mind. lol. Thanks so much!!!
      • _MartinB's avatar
        _MartinB
        Iron Contributor
        no worries; I just knew the answer since I had the same problem before 😄

Resources