SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


set [field4] = 3

Any guidence would be appreciated. Thanks!

share|improve this question

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

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"),
     IF ( OR([field1]="denied",[field2]="denied",[field3]="denied"),

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

share|improve this answer

Your Answer


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