SharePoint Calculated List Column

%3CLINGO-SUB%20id%3D%22lingo-sub-49784%22%20slang%3D%22en-US%22%3ESharePoint%20Calculated%20List%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-49784%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%2C%20I%20have%20a%20calculated%20column%20which%20reads%20data%20from%20a%20column%20that%20contains%20numbers%20like%201%2C%202%2C%203%2C%204%20etc..I%20want%20the%20calcualted%20column%20to%20check%20the%20current%20number%20and%20then%20assign%20a%20string.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20code%20is%20as%20follows%3A%3C%2FP%3E%3CP%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%221%22%2C%20%22January%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%222%22%2C%20%22February%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%223%22%2C%20%22March%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%224%22%2C%20%22April%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%225%22%2C%20%22May%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%226%22%2C%20%22June%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%227%22%2C%20%22July%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%228%22%2C%20%22August%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%229%22%2C%20%22September%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%2210%22%2C%20%22October%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%2211%22%2C%20%22November%22%2C%22No%20date%22)%3CBR%20%2F%3E%3DIF(%5BMonth%20(Calculated)%5D%3D%2212%22%2C%20%22December%22%2C%22No%20date%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20with%20this%20nested%20if%3F%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
Senior Member

Hi Everyone,

 

Please help, I have a calculated column which reads data from a column that contains numbers like 1, 2, 3, 4 etc..I want the calcualted column to check the current number and then assign a string.

 

The code is as follows:

=IF([Month (Calculated)]="1", "January","No date")
=IF([Month (Calculated)]="2", "February","No date")
=IF([Month (Calculated)]="3", "March","No date")
=IF([Month (Calculated)]="4", "April","No date")
=IF([Month (Calculated)]="5", "May","No date")
=IF([Month (Calculated)]="6", "June","No date")
=IF([Month (Calculated)]="7", "July","No date")
=IF([Month (Calculated)]="8", "August","No date")
=IF([Month (Calculated)]="9", "September","No date")
=IF([Month (Calculated)]="10", "October","No date")
=IF([Month (Calculated)]="11", "November","No date")
=IF([Month (Calculated)]="12", "December","No date")

 

Can anyone help with this nested if? Thank you

0 Replies