How can I change the column of a table for an arrow sign?

[Anonymous]

Hi,

I have a table, and according to the value of a field, I will like to display an arrow, I have tried in the backgroun, text format, and text color, but didn't work. I am trying to add the following condition for the field:

=If ([Current Trend]='Improving', 'qmem://<bundled>/BuiltIn/arrow_ne_r.png',

If ([Current Trend]='Neutral', 'qmem://<bundled>/BuiltIn/arrow_e_y.png',

  If ([Current Trend]='Hot', 'qmem://<bundled>/BuiltIn/arrow_se_g.png')))

How can display an arrow in the column instead of the value itself?

[vishsaggi]

Like in Expression Tab -> click + -> Text Color write below

=If ([Current Trend]='Improving', Green(),

If ([Current Trend]='Neutral', LightGray(),

If ([Current Trend]='Deteriorating', Red())))

[Anonymous]

Now, I have the arrows, but how can I give them a different color, I have tried this in the definition for background and text color:

If ([Current Trend]='Progressing', RGB(97,255,51),
If ([Current Trend]='Caution', RGB (255,246,51),
If ([Current Trend]='Hot', RGB (255,76,51))))

But this is not doing anything, am I missing something?

[vishsaggi]

Hello Robert,

Could you able to change the color of those arrows ? Did you try ?

[Anonymous]

Yes, I have the following there:

=If ([Current Trend]='Improving', Green(),
If ([Current Trend]='Neutral', Yellow(),
If ([Current Trend]='Deteriorating', Red())))

But nothing happened, I have tried using the RGB() but it does not work neither.

[vishsaggi]

Try this in the Text Color

= Pick(Match([Current Trend], 'Improving', 'Neutral', 'Deteriorating'), Green(), Yellow(), Red())

[Anonymous]

Still not working, I don't know what to test, as information these fields are in a Straight table, does that make any change?

[Anonymous]

Hi

Add ' = ' in first line before If. It will work

=If ([Current Trend]='Progressing', RGB(97,255,51),
If ([Current Trend]='Caution', RGB (255,246,51),
If ([Current Trend]='Hot', RGB (255,76,51))))

Hope it helps!!

[Anonymous]

I have the '=' at the beginning. I don't know what is going on. It worked for background color in another straight table and is not working here.

[Anonymous]

I have fixed it, I have 2 columns with the same name, when I changed the names and it's working now. Thank you!!!!