Formula Not Providing a Value

Question

Hi team, I hope all is well.

At the moment, I'm trying to assign 1-6 "Level Results" based on conditional logic but for some reason, 5 out of the 6 formulas are not providing a value at all.

Below are the parameters, workflow with formulas, and data.

Qiu · Answer

@jalizmaldonado 
Somehow I get what you need to do.

But can you check your data again, since I dont have any match even I check manually based on your cretiria.

Say the location as 4787 doest not exist.

jalizmaldonado · Answer

@Qiu  @MarqueeCrew Hi, just realized I didn't include the data or the workflow from this point.

Level Results.yxmd

Conditional Job Codes.xlsx

Qiu · Answer

@jalizmaldonado

You OR is wrong, I think.

It should be something like

[Job code] !="T0622" or [Job code] !="M1023"