Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Another SharePoint Caluculated Field Help

Posted on 2013-12-23
3
Medium Priority
?
240 Views
Last Modified: 2014-01-20
I have a SharePoint List 2010 which I would like to add a calculated value to...

New column called Segment
 
= Defense/Fedsec if Owner Hierarchy contains Defense
= S&L if Owner Hierarchy contains SLED
= CS/Intel if Owner Hierarchy contains Consult
= Civilian if Owner Hierarchy contains Civilian
= Healthcare if Owner Hierarchy contains Healthcare
0
Comment
Question by:Matt Pinkston
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Accepted Solution

by:
Matt Pinkston earned 0 total points
ID: 39736479
I think I got the code?

=IF(ISNUMBER(SEARCH("defense",[Owner Hierarchy])),"defense",IF(ISNUMBER(SEARCH("civilian",[Owner Hierarchy])),"civilian", IF(ISNUMBER(SEARCH("sled",[Owner Hierarchy])),"S&L",IF(ISNUMBER(SEARCH("healthcare",[Owner Hierarchy])),"healthcare",IF(ISNUMBER(SEARCH("consulting",[Owner Hierarchy])),"CS","")))))
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39736572
Hi,

looks OK like EE already solved.

HTH and merry christmas
Rainer
0
 

Author Closing Comment

by:Matt Pinkston
ID: 39793749
I fund my own answer
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

704 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