Skip to main content
Question

Contains"" Formula Help

  • March 3, 2015
  • 0 replies
  • 56 views
Forum|alt.badge.img+6

There are extra characters beyond the end of the formula.

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"))
I keep adding and removing commas and parenthesis and I'm not sure how to get it right.
Can you correct and mark your additions in red (and/or deletions in strikeout?)
Thank you!
This topic has been closed for replies.

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.
Forum|alt.badge.img+6
  • AmberPollard
  • Author
  • Registered
  • March 3, 2015
Gee whiz, it works! Thanks, mister!
Terms & ConditionsAccessibility statement