Sharepoint Calculated Column

%3CLINGO-SUB%20id%3D%22lingo-sub-2323289%22%20slang%3D%22en-US%22%3ESharepoint%20Calculated%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2323289%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20trying%20to%20figure%20out%20an%20IF%20formula%20for%20a%20Sharepoint%20Calculated%20Column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20A%20%3D%20IA%2C%20IB%2C%20IC%2C%20ID%2C%26nbsp%3BIIA%2C%20IIB%2C%20IIC%2C%20IID%2C%26nbsp%3BIIIA%2C%20IIIB%2C%20IIIC%2C%20IIID%2C%26nbsp%3BIVA%2C%20IVB%2C%20IVC%2C%20IVD%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20a%20calculated%20column%20where%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIF%20Column%20A%20%3D%20IA%2C%20IB%2C%20IIA%2C%20then%20calculated%20column%20%3D%201%3C%2FP%3E%3CP%3EIF%20Column%20A%20%3D%20IC%2C%20IIB%2C%20IIIA%2C%20then%20calculated%20column%20%3D%202%3C%2FP%3E%3CP%3EIF%20Column%20A%20%3D%20ID%2C%20IIC%2C%20IIIB%2C%20IVA%2C%20then%20calculated%20column%20%3D%203%3C%2FP%3E%3CP%3EIF%20Column%20A%20%3D%20IID%2C%20IIIC%2C%20IVB%2C%20then%20calculated%20column%20%3D%204%3C%2FP%3E%3CP%3EIF%20Column%20A%20%3D%20IIID%2C%20IVC%2C%20then%20calculated%20column%20%3D%205%3C%2FP%3E%3CP%3EIF%20Column%20A%20%3D%20IVD%2C%20then%20calculated%20column%20%3D%206%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2323289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I've been trying to figure out an IF formula for a Sharepoint Calculated Column.

 

Column A = IA, IB, IC, ID, IIA, IIB, IIC, IID, IIIA, IIIB, IIIC, IIID, IVA, IVB, IVC, IVD

 

I want a calculated column where:

 

IF Column A = IA, IB, IIA, then calculated column = 1

IF Column A = IC, IIB, IIIA, then calculated column = 2

IF Column A = ID, IIC, IIIB, IVA, then calculated column = 3

IF Column A = IID, IIIC, IVB, then calculated column = 4

IF Column A = IIID, IVC, then calculated column = 5

IF Column A = IVD, then calculated column = 6

 

Any ideas

1 Reply

@petertheo89 Try using below formula:

 

=IF(OR([Column A]="IA", [Column A]="IB", [Column A]="IIA"), 1, IF(OR([Column A]="IC", [Column A]="IIB", [Column A]="IIIA"), 2, IF(OR([Column A]="ID", [Column A]="IIC", [Column A]="IIIB", [Column A]="IVA"), 3, IF(OR([Column A]="IID", [Column A]="IIIC", [Column A]="IVB"), 4, IF(OR([Column A]="IIID", [Column A]="IVC"), 5, IF([Column A]="IVD", 6, 0))))))

 

Return the calculated field as Number.

 

Note:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

 

Official Documentations:

  1. Calculated Field Formulas.
  2. IF function.

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.