Change imagem - Two conditions - Textbox

[Anonymous]

Hello,

Does Anybody knows how to change imagem with two conditions in text object?

I tried 2 ways, but they don't work.

=if([project] = 'Security Operations' and  [Fase 1] = 'On time', 'qmem://Img_id/green',

if([project] = 'Security Operations' and  [Fase 1] = 'Late', 'qmem://Img_id/red'))

=if(([project] = 'Security Operations' and  [Fase 2] = 'On time'),'qmem://Img_id/green', 'qmem://Img_id/red')

This last way, shows only the last image (red), even I change the "Fase 2" status.

Thank you for your attention.

[Anil_Babu_Samineni]

You should select project and Fase2 then only Green come due to AND operator. Or you can use OR operator for that.

[vvira1316]

try this

=if([project] = 'Security Operations', If([Fase 1] = 'On time', 'qmem://Img_id/green', 'qmem://Img_id/red'))

[Anonymous]

Unfortunately, It didn't work.

[Anonymous]

Unfortunately, It didn't work.

[vvira1316]

Would it be possible for you to share sample data and/or app file. You can mask data, refer to Preparing examples for Upload - Reduction and Data Scrambling

[Anonymous]

Here you go.

Thank you so much

[vvira1316]

You have following script. Field names are different in script and in your question. Also looking at this data information I'm not seeing data values that will provide 'On time' and  'Late' or even Fase 2 so can you please guide here.

LOAD [Projetos Fase 1],
[Status Fase 1]
FROM
[..\plan db.xlsx]
(ooxml, embedded labels, table is [Fase1-DOD]);

Projetos Fase 1	Status Fase 1
Security Operations	Em andamento - Em dia
Rede Virtualizada	Em andamento - Atrasado

Also it would not work in the text as you have set it up.

Not sure if following is what you are expecting

=if([Projetos Fase 1] = 'Security Operations',
If([Status Fase 1] = 'Em andamento - Em dia',
'qmem://<bundled>/BuiltIn/check_g.png', 'qmem://<bundled>/BuiltIn/exclamation_r.png'),
'qmem://<bundled>/BuiltIn/check_g.png')

[vvira1316]

You have data issue..

Please refer to image below.

In above case It is not Security Operations and Em andamento - Em dia so it should give you red which it is giving

I reloaded data using your sample data file and I get following.

In above case It is Security Operations and Em andamento - Em dia so it should give you green which it is giving

Also your text object will respond if you had a list box to select Status Fase 1 field values as seen in images below

Here I've used same expression that you had

[Anonymous]

This way, I need to select field in table to change image and its not work for me.

I need that the image change according is set in spreadsheep (db)  field only.

when project load -- if  the value in the field (db) is one, green else red.

I cannot select field in the table inside project.

😞

Thanks for all