• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Another SharePoint Caluculated Field Help

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
Matt Pinkston
Asked:
Matt Pinkston
  • 2
1 Solution
 
Matt PinkstonAuthor Commented:
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
 
Rainer JeschorCommented:
Hi,

looks OK like EE already solved.

HTH and merry christmas
Rainer
0
 
Matt PinkstonAuthor Commented:
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!

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