1

Sharepoint 2010 Looking for some help here as I'm sure its a simple solution.

I have: 2 Yes/No Columns: DivisionA, DivisionB (I will have a total of 15 divisions but using 2 for an example) 1 Calculated column: Divisions

I would like to have the calculated column return A, B, and/or C depending if any of the yes/no columns were checked.

I have used the following below but it will only return one statement.

=IF([DivisionA]=TRUE,"A",IF([DivisionB]=TRUE,"B",""))
  • 2
    So you want the letter of every division where it is true? Try IF([DivisionA]=TRUE,"A","") & IF([DivisionB]=TRUE,"B","") & ... – tweytjens Apr 28 '14 at 14:29
0

tweytjens is right. You have to use the "&" to join the different values (I would rather use &" / "&).

Your Answer

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

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