One of the questions posted recently on the SUGUK forums was, ‘How do I get my content into SharePoint and tag it to enable search, without the pain of uploading it one by one……†It’s a good question and one that comes up many times, otherwise, people like Quest and Metalogix wouldn’t have their migration …
Category: Calculated Fields
Oct 06
Whats the record for the longest Calculated SharePoint column?
Well my longest to date is 304 characters.. I’m not quite sure what the SharePoint limit is, but here’s mine… =IF(LEN(MONTH(Dated)/3)=1,TEXT(Dated,”mmm-yy”),IF(LEN((MONTH(DATE(YEAR(Dated),MONTH(Dated)+1,DAY(Dated))))/3)=1,TEXT(DATE(YEAR(Dated),MONTH(Dated)+1,DAY(Dated)),”mmm-yy”),IF(LEN((MONTH(DATE(YEAR(Dated),MONTH(Dated)+2,DAY(Dated))))/3)=1,TEXT(DATE(YEAR(Dated),MONTH(Dated)+2,DAY(Dated)),”mmm-yy”),”ERR”))) “And what pray, does that monstrosity do”, I hear you ask… The answer is, it simply works out which quarter of the companies financial year the item appears in. The list item has a …