Contains"" Formula Help
There are extra characters beyond the end of the formula. If (Contains([filepath], "corresp") OR contains([filepath], "letter") OR contains([filepath], "memo"), "Correspondence") , (Contains([fil...
Forum Discussion
Not tested by try this
IF(
Contains([filepath], "corresp") OR contains([filepath], "letter") OR contains([filepath], "memo"), "Correspondence",
Contains([filepath], "newsletters"), "Member Materials/Notices",
Contains([filepath], "minutes"), "Minutes/Agenda",
Contains([filepath], "data"), "Data",
Contains([filepath], "template"), "Template")
Too many brackets is a hazard to your mental health.
IF(
Contains([filepath], "corresp") OR contains([filepath], "letter") OR contains([filepath], "memo"), "Correspondence",
Contains([filepath], "newsletters"), "Member Materials/Notices",
Contains([filepath], "minutes"), "Minutes/Agenda",
Contains([filepath], "data"), "Data",
Contains([filepath], "template"), "Template")
Too many brackets is a hazard to your mental health.