locked
Calculated field column - number of characters RRS feed

  • Question

  • Hi,

    I had added a validation for list items in my SharePoint list by going to List settings--> Validation settings, it worked fine until i added few more lines of logic to it. Does calculated column has hard limit on number of characters?

    Thanks


    Wednesday, April 30, 2014 12:03 PM

Answers

  • Calculated Column Limits is 1024 Characters

    http://sharepointkb.wordpress.com/2009/02/10/calculated-column-limits-1024-characters/

    But do check below as well

    http://social.technet.microsoft.com/Forums/sharepoint/en-US/9acd357f-b329-473a-8f95-df7dfd62d1a2/maximum-numbers-of-characters-in-calculated-column?forum=sharepointgenerallegacy

    Wednesday, April 30, 2014 12:43 PM
  • maximum characters limit is 1024. Refer this link

    find the workaround for nested conditions here


    Senthilrajan Kaliyaperumal


    Wednesday, April 30, 2014 12:47 PM

All replies

  • Yes, It allows only 256 characters

    Senthilrajan Kaliyaperumal

    Wednesday, April 30, 2014 12:22 PM
  • Thanks for the quick response Senthilrajan.

    My question was on number of characters allowed in Formula section not the output. I already had a working validation with more than 256 characters, it failed when i added few more lines of logic.

    Thanks.

    Wednesday, April 30, 2014 12:26 PM
  • Calculated Column Limits is 1024 Characters

    http://sharepointkb.wordpress.com/2009/02/10/calculated-column-limits-1024-characters/

    But do check below as well

    http://social.technet.microsoft.com/Forums/sharepoint/en-US/9acd357f-b329-473a-8f95-df7dfd62d1a2/maximum-numbers-of-characters-in-calculated-column?forum=sharepointgenerallegacy

    Wednesday, April 30, 2014 12:43 PM
  • maximum characters limit is 1024. Refer this link

    find the workaround for nested conditions here


    Senthilrajan Kaliyaperumal


    Wednesday, April 30, 2014 12:47 PM