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'm trying to build a calculated field with the following condition:

if [field1], [field2], [field3] = approved

set [field4] = 1

if [field1], [field2], [field3] = denied 

set [field4] = 2

else

set [field4] = 3

Any guidence would be appreciated. Thanks!

share|improve this question
add comment

2 Answers

The syntax for calculated columns is basically the same as Excel. What I usually do is dummy up the formula in Excel and then copy it over, replacing the cell references with column names.

share|improve this answer
    
a sample formula would really help me out. thanks! –  user2094 Mar 30 '11 at 14:22
add comment

Full reference guide for SharePoint Functions

Off the top of my head (haven't tested so could be typos)

Set Field4 as calculated field.

Set its calculation to :- (formatted for easier reading)

IF ( OR([field1]="approved",[field2]="approved",[field3]="approved"),
     "1",
     IF ( OR([field1]="denied",[field2]="denied",[field3]="denied"),
          "2",
          "3"
         )
    )

For troubleshooting break this down into the constituent parts, (separate out OR and IF) and test each one individually.

share|improve this answer
add comment

Your Answer

 
discard

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