Calculated Column in Sharepoint Error

Question

I have list in which i have 33 columns datatype of number. I have one calculated column in which i have to find average for the all the 33 column . It was allowing me to add 30 column but when i am trying to add 31st column it throws error. Is there any limitation like maximum number of column allowed for calculated column?

Manesh Golekar · Answer

What errror message you are getting while adding

Antony · Answer

Yes krishna but all together its not more than 400characters. In calculated column whether we can add oly 30 column maximum to find average? Is there any limitation like that in sharepoint for calculated column?

Krishna · Answer

Hi Reginold, There is a limit of 1024 characters in the formula section of calculated column. So you can take average of 15 columns in first calculated column and average of 18 columns in second calculated column. Then use third calculated column to take average of those two calculated columns. Hope this suffice your problem. Thanks, Krishna

Antony · Answer

Thanks krishna. But my issue is that i have created 33 number column i should do average for all the 33 column in the calculated column. It allow to add 30 column when adding 31st column it throws error. Is there any limitations for calculated column that it can hold only 30 column to find average?

Krishna · Answer

You can create the following numbers of each column type for each list or library: 64 Single line of text and Choice (drop-down menu or radio buttons) 31 Multiple lines of text and Choice (check boxes (allow multiple sections)) 32 Number and currency 32 Hyperlink 16 Date and time 16 Lookup 16 Yes/No 8 Calculated Thanks, Krishna