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