The expression above =IF(OR(A10="True",B10="True",C10="True"),"TRUE",IF(AND(A10="False",B10="False",C10="False"),"FALSE","Unknown"))
works when I use anything other than "TRUE" or "FALSE". I guess that means the values are automatically converting to boolean and this formula does not like that. I cannot even replace the values as they are all look-ups. Making a hidden column to evaluate the boolean values to something else does not work either, because of the boolean values starting point...
Thank you all for your help, I am open to further ideas if any. Otherwise I will do it manually.
To explain in words: If ANY of the first 3 columns are TRUE, return "TRUE". If ALL of the first 3 columns are FALSE, return "FALSE". Any other combination should return "UNKNOWN"
CONFIG_REQ PACK_REQ ACCSY_REQ Expected Result Actual Result
Yes No No TRUE TRUE
No No No FALSE FALSE
B B UNKNOWN UNKNOWN
TRUE FALSE FALSE TRUE UNKNOWN
FALSE FALSE FALSE FALSE UNKNOWN
FALSE FALSE UNKNOWN UNKNOWN
