Forum Discussion

AmberPollard's avatar
AmberPollard
Qrew Assistant Captain
11 years ago

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([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!
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    11 years ago
    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.