I am creating a new column type in a SharePoint 2013 Online Document Library in order to parse a file name.

Currently I have this formula I can add into =MID([Title],1,FIND(".",[Title],1)-1)

This parses my folder John.Smith and gives me John. Although for my Adobe PDF it gives me #Name?

Do you know how to make it parse the PDF and Excel file as well?


enter image description here

This is the picture of what I was saying. enter image description here

  • 1
    It should work if you edit the pdf metadata and add a Title to the document. Jul 25 '14 at 21:26

The Name column cannot be referenced in a calculated column. You can see proof of this by looking through the list of Columns available when creating or editing your calculated column formula.

If you want to work around the issue, create a second column and then use a workflow to copy the Name column to the new column you created. The new column can be referenced in your calculated column.

The easiest way to create the workflow would be in SharePoint Designer. Set the workflow to start anytime an item is created or changed and the one step would be to set your new column to the value of the Name column.

Creating the workflow is very easy. Once you have downloaded and installed SharePoint Designer, connect to your site and create a new Workflow (a 2010 workflow is sufficient for this purpose). Set up the workflow as follows. The first image shows the workflow settings and the second image shows the single step you'll need to create. In the second image, NameCopy is the name of the column I am copying the Name column into.

enter image description here

  • 1
    If you look at his formula, he isn't using the Name field at all Jul 25 '14 at 21:36
  • Name & Title are oddly the same. Jul 25 '14 at 21:41
  • Is there a Lag in Sharepoint before it works? Jul 25 '14 at 22:16
  • Set NameCopy to [%Current Item:Name%]...... Why does it have %? Jul 25 '14 at 22:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.