Ignore blanks while detecting matching text across multiple columns
Hello! I am trying to write a formula for detecting ANY matches between "Affiliation" and "Affiliation 1," "Affiliation 2," or "Affiliation 3". If any of them match "Affiliation", then "conflict" is true. If false, it should say "none".
However, if "Affiliation" is blank and matches another blank, it also outputs "conflict".
How do I exclude the blanks? I think I need to use ISBLANK but cannot figure out how to integrate it.
Help Article Resources
Check out the Formula Handbook template!