Sharepoint 2010 Calculated Column based on Name field

sharepoint sharepoint-2010 sharepoint-designer sharepoint-workflow
Allan Bowe picture Allan Bowe · Jul 18, 2012 · Viewed 13.2k times · Source

I need to get around the restriction that prevents the use of the Name column in a calculated column.

I basically need to create a new library column (BeginsWith) which is the first three letters of the value of (Name) - eg turning "analysis_type_dim" into "ana"

This can be done from the Title column but not the Name column (via the UI). I tried creating a looping workflow but Microsoft have disabled this in 2010 :(

Answer

namefieldcleared picture namefieldcleared · Jul 31, 2012

You could create a new colum NameAsText and set the field with a workflow to the value of the field "name". Then you could create a new calculated colum with the formula =mid([NameAsText];1;3) and you will get the first three letters of the "name"-field.

Related questions

SharePoint 2010 workflows suddenly does not work

I've been having this issue and been looking for a solution to no avail. Situation A: We have a SharePoint 2010 site which contains a list that has a SharePoint Designer workflow. Now everything seems to be working fine, the workflow …

Read More
SharePoint 2010 - Create liste items with looping workflow - limitation of 5?

I have a little problem creating new list items (rows) with the help of a workflow in a list in SharePoint Server 2010. Here are the facts. What I want to do: Create an item in a main list. While creating …

Read More
Change SharePoint Library URL

How do you change the URI of a SharePoint library? Based on Google searching, most people say that changing the name of a library in Designer (via right click->rename) will result in the URI change, but it is …

Read More