Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

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
0
Matt Pinkston
Asked:
Matt Pinkston
1 Solution
 
Rainer JeschorCommented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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