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!


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.

| 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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy