Filtering with complex criteria

[SH_94]

Dear community,

I would like to ask how we can flag those line which is not as per the criteria below :

Criteria

1 Under each ID, every line for the "GBV_FF" ,it would need to be appear under negative column (which mean positive will be zero) and each line for the "OC", it would need to appear under positive column - This ID will be categorised as Correct ID (as per example screenshot below).

2. Under each ID , If "GBV_FF" appear under positive column and "OC"appear under negative column, This ID will be categorised as Incorrect ID.  (as per example screenshot below).

3. Under each ID , If "GBV_FF" appear under positive column and "OC"appear under negative column . This ID will be categorised as Incorrect ID despite we have more and others mapping .As long as " If "GBV_FF" appear under positive column and "OC"appear under negative column, it will automatically appear as Incorrect ID.

For example, in the screenshot below, we have "GBV_FF" , "MS", "OC". Despite we have additional or other item like "OC" under one ID, as long as "GBV_FF" show positive column and "OC" show negative column, it will flag as Incorrect ID 

May i know how can we fix for this part?

Thank you

[atcodedog05]

Hi @SH_94 

Here is how you can do it.

Workflow:

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

Thank you for your prompt response.

I was looking at the solution and i forget to add in overall criteria

Overall criteria

For the above three criteria listed, it actually applicable only if the each ID consist of "GBV_FF" and "OC" disregard whether it is positive or negative.

If "GBV_FF" or "OC" missing under one ID, it will flag as N/A ID.

Do you know how to fix this part? For example , the line below should be flag as N/A ID.

Thank you.

[atcodedog05]

Hi @SH_94 

Here is the updated workflow

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

Many thanks for the prompt response.

May i know if i have more than 40 item that i want to include under the "mapping" as per screenshot below, how can we include everything? Can we use contain formula? Do you know how to use contain formula in this case?

For example , in the screenshot below, i only included " GBV_FF". In my actual list, i have more than 40 line that i want to include and for example in the list below

1. GBV_FF

2.AA

3.BB

4.CC

5.DD

6.EE

7.FF

Many thanks again for your resposne.

[atcodedog05]

Hi @SH_94 

Here is how you can do it.

Workflow:

Hope this helps : )

[SH_94]

Hi @atcodedog05 ,

Thank you for the prompt response. If i want to include more items using the formula example below, is there anyway to add item apart from the once u just shared?

Thank you.

[atcodedog05]

Hi @SH_94 

In the new one you can just define the check in the list and it will compare which is much more flexible.

Hope this helps : )