[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1215
  • Last Modified:

Help with SharePoint list calculated field or filter

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
0
Matt Pinkston
Asked:
Matt Pinkston
  • 2
1 Solution
 
colly92002Commented:
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")
 
e.g.
=ISERR(SEARCH("String I am searching for",[ColumnName],1))

returns "Yes" where the field you are searching in does not contain the string.
0
 
Matt PinkstonAuthor Commented:
so the though here is how would I combine the following in such a statement

if TOV or EV GE 5000000
AND
if Opportunity Name does not contain "Option Y"
if Opportunity Name does not contain "Option P"
0
 
colly92002Commented:
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:
http://sharepoint.rackspace.com/calculated-columns-tutorial
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now