locked
Condense multiple IF statements into an OR function? RRS feed

  • Question

  • I've written a long formula for a calculated field in a Sharepoint list which maxed out the character limit. The formula contains many different conditions that would return the same value. See example below:
    =IF([Request Type]="Create Metadata in MDB","Data Team",
    IF([Request Type]="Update Metadata Record","Data Team",
    IF([Request Type]="Process Vendor Test Cases","Data Team",
    IF([Request Type]="Process Opt Out File","Data Team"
    IF([Request Type]="Create Metadata in Unica","Unica Team"
    ..........
    I thought I might be able to shorten the formula by including the conditions which return the same value in a single OR function like so:
    =IF([Request Type]=OR("Create Metadata in MDB","Update Metadata Record","Process Vendor Test Cases","Process Opt Out File"),"Data Team"
    ...........
    Although SharePoint accepts this syntax, #VALUE is returned.
    Any suggestions on how to make this work? Or other suggestions on how to shorten my formula?
    Thanks!
    J
    • Moved by Mike Walsh FIN Friday, August 26, 2011 3:21 PM forumula questions are admin (use of standard function) not customization (From:SharePoint - Design and Customization (pre-SharePoint 2010))
    Friday, August 26, 2011 2:51 PM

Answers