Solved

SharePoint calculated field help

Posted on 2013-12-23
1
312 Views
Last Modified: 2014-01-15
Need some help on a sharepoint calculated field....
 
I want to create a column called status and I want that field to be either open or closed
 
The column that dictates this is Opportunity Status

If Opportunity Status = Open then Status should = Open
if Opportunity Status = Anything Else other than Open then Status should = Closed
0
Comment
Question by:Matt Pinkston
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
Comment Utility
Hi,

the formula should look like:
=IF(LOWER([Opportunity Status]) = "open","Open",[Opportunity Status])

Open in new window


But it could depend on the type of your "Opportunity Status" field.
Which SharePoint version/edition?

HTH and merry Xmas
Rainer
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

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…
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

772 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now