Hello nintex lovers, I need your help for this formula please
Here is what I need to do
| If A= "High" or B= "High" or C= "High" or D= "High" ==> "High" else If X= "Yes" or V= "Yes" or N= "Yes" or H= "Medium" or P= "Medium" or M= "Medium" or L= "Medium" ==> "Medium" else "Low" |
And here is the formula I have set up.
If(or(or(or(A=='High', B=='High'),C=='High'),D=='High'),'High',If(or(or(or(or(or(or(X=='Yes', V=='Yes'),N=='Yes'),H=='Yes'),P=='Yes'),M=='Yes'),L=='Yes'),'Medium','Low'))
High and Low values work perfectly but not Medium, do you see anything wrong please ???
Thanks
