Sharepoint Calculated Column With Multiple Lines Of Text

Feb 02, 2012  Hi. I am using SharePoint 2010. I have a list with below columns: Column Name Data Type. 1) Description multiple lines of text. 2) Status Single line of text. I need to create a calculated column by concatenating these 2 columns. But when I try to create a calculated column, I am not able to see 'Description' column in the 'Insert Column' section. May 22, 2012  In the regular SharePoint 2010 interface you can't change the type of the Title field from a single line of text to a calculated column. But this where the most awesome feature of SharePoint 2010 (in my humble opinion) comes in: customizing the form of your list with InfoPath 2010.

• Sharepoint Calculated Column With Multiple Lines Of Text In Excel Cell
• Sharepoint Calculated Column Text Format

I had a form in production that a client was using to track requests for items that required justification. During testing, we noticed that once the form was submitted, the rich-text field in InfoPath displayed as a Single Line of Text field in SharePoint but the client was sure that all justifications would be short. Famous last words. Several users wrote novels and when (oops!) we added an approval to the request directly in SharePoint, we lost all but the first 255 characters of the novel!The solution didn't help us retrieve the lost novels/justifications, but we were able to figure out how to get all the information to map to a rich text field in SharePoint, even if the approach requires several steps. The solution is the following:After you publish the form to SharePoint the first time, go to the SharePoint list and create a new column with a type of Multiple Lines of Text.

If you think people will be writing a lot of text in the field, be sure to select the 'allow unlimited length in document libraries' button. Further reading: Then, go in to the InfoPath form and in the publishing wizard where you choose which fields to promote to SharePoint, highlight your source field and hit Modify. Then, map your source field in InfoPath to your newly created multi-line text field in SharePoint and all the characters typed in by the user will transfer to SharePoint and you won't lose them (even if you may want to!).If users do write lots and lots of text in the form field, your SharePoint views will not be pretty, but all of the information will be visible. Fortunately, we only had a few cases where we'd edited the form data from SharePoint and the user wrote lengthy justifications so the impact was not devastating.It took me several attempts at crafting a Google search to resolve this issue so I hope this helps someone else (or gets someone to identify a better way).

Sharepoint Calculated Column With Multiple Lines Of Text In Excel Cell

Hello,I have a list with version history and one multiline text column that appends the text. The problem is that when we export the SharePoint list to Excel we only get the current version of each item so past versions of appended text column are lost (or stuck in the list).This got me thinking about ways to at least help the users out by making a workflow or calculated column that lets them know what multiline fields in each items even contain data in any version of the item. Does anyone have any tricks or tips related to finding out what appending multiline text fields contain data or perhaps ways of exporting with version history?

Sharepoint Calculated Column Text Format

I found this online and it is what i needed.