Combining Not Contains and Contains into the same formula
The below formula. I am trying to combine these validations into one statement. If any of them are true, the row should flag as yellow. If any of them are false, it should flag as green. However, the statement is flagging as "green" when "warning records" is not found. It should flag as yellow.
This is the content that should result in the row being "yellow":
This is the statement that appears to be wrong. The "Contains" flag yellow properly, but the "Not Contains" does not. Does anyone know how this statement should be corrected so that if any of these conditions are met, it flags as "yellow". If none of them are met, it should flag as green.
=IF(LEN(Body@row) < 1, "RED", IF(OR(CONTAINS("Injury Date", Body@row), CONTAINS("Client", Body@row), CONTAINS("saving claim", Body@row), CONTAINS("ReadOnly", Body@row), CONTAINS("User Exception", Body@row), CONTAINS("not a Active/Reporting Location.", Body@row), CONTAINS("Request Channel", Body@row)), "Yellow", IF(NOT(CONTAINS("Warning message:", Body@row)), "Yellow", "Green")))
Help Article Resources
Check out the Formula Handbook template!