Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
If the text field contains both "A" and "B", then it should result in "AB".
Text_Field__c, "A" & "B"
It goes through; there are no syntax errors. But it doesn´t work.
You need to use && operator :
if((contains(Text_Field__c, "A") && contains(Text_Field__c, "B")), "AB", "")
Or use AND operator :
IF(AND(contains(Text_Field__c, "A"), contains(Text_Field__c, "B")), "AB", "")
Required, but never shown