Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I want to create a column in sharepoint 2010 foundation custom list which functions as the below code

If (Status = "Avail") then -1 ElseIf ((Status = "Apply") then 1 End IF

meaning that when ever while adding an item in the list the new column should have value 1 or -1 according to the option selected in column Status as Apply or Avail respectively.

Is it possible to create such a column

share|improve this question
add comment

1 Answer

up vote 5 down vote accepted

You'd want to do something like this:

=IF([Status]="Avail", "-1", "1")

This is a great resource on calculated columns.

share|improve this answer
    
Great Thanks Very Much It worked! –  daveshborasi May 15 '12 at 15:26
    
Great! Since it resolved your issue, you can click the little check mark to show that. –  PirateEric May 15 '12 at 15:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.