Help with SharePoint list calculated field or filter

Posted on 2014-08-12
Last Modified: 2014-09-03
I have a sharepoint list and I need the ability to either add a filter that says "DOES NOT CONTAIN" which I cant find or add a calculated field to the list that could be set if another field DOES NOT CONTAIN a certain phrase
Question by:Matt Pinkston
    LVL 15

    Expert Comment

    You can use "SEARCH" to find a string in a string (i.e. does contain), and use the ISERR function which returns YES when an error (i.e. "does not contain")
    =ISERR(SEARCH("String I am searching for",[ColumnName],1))

    returns "Yes" where the field you are searching in does not contain the string.

    Author Comment

    by:Matt Pinkston
    so the though here is how would I combine the following in such a statement

    if TOV or EV GE 5000000
    if Opportunity Name does not contain "Option Y"
    if Opportunity Name does not contain "Option P"
    LVL 15

    Accepted Solution

    Off the top of my head, it will be something like:

    =IF(AND(TOV >= 5000000,
      OR(ISERR(SEARCH("Option Y",[Opportunity Name],1)),
            ISERR(SEARCH("Option P",[Opportunity Name],1)) = "Yes")
                 ), "DOES NOT CONTAIN", "DOES CONTAIN"

    Have a look here to learn the syntax and refine if required:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
    For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now