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.
pic is too blurry for my eyes.
but
[job code] Not In ("ddddd","fffff","zzzzzz")
cheers,
mark
You OR is wrong, I think.
It should be something like
[Job code] !="T0622" or [Job code] !="M1023"
@Qiu @MarqueeCrew Hi, just realized I didn't include the data or the workflow from this point.
@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.