Matt Pinkston
asked on
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
ASKER
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"
if TOV or EV GE 5000000
AND
if Opportunity Name does not contain "Option Y"
if Opportunity Name does not contain "Option P"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.