SharePoint calculated field help

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
Matt PinkstonAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rainer JeschorConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.