Solved

Another SharePoint Caluculated Field Help

Posted on 2013-12-23
3
235 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
  • 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

Industry Leaders: 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!

Question has a verified solution.

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

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
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...

713 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