Nested if + wildmatch

[MT4T]

Hi,

I have struggle with this calculated field I need to make.

In first case i need to mark all rows that contains "TBC" in field Customer PO as "DUMMY-COMMITED"

In secon case i need to mar all rows that contains "DUMMY" as "DUMMY"

Rest should be marked as "COMMITED"

Is there any expression that should solve this?

l(If(WildMatch([Customer PO],'TBC'),'DUMMY-COMMITED',(IF(WildMatch([Customer Code],'DUMMY'),'DUMMY','COMMITED'))))

[Rockstar7]

@MT4T 

Provide any sample data to understand better

[BrunPierre]

@MT4T Per your logic this simple statement in the script should work

IF([Customer PO]='TBC','DUMMY-COMMITED',
IF([Customer Code]='DUMMY','DUMMY','COMMITED') AS [Field Name]

[sidhiq91 · Accepted solution]

@MT4T As @BrunPierre  mentioned you can just use his logic, or if you wanted to use wildmatch in your expression there is a slight change, please see as below:

if(wildmatch([Customer PO],'*TBC*'),'DUMMY-COMMITED',

if(wildmatch([Customer PO],'*DUMMY*'),'DUMMY','COMMITED'))

[MT4T]

Thank you, save my day. The missing "*" was an issue.