Forum Discussion
Working with the file name
It's a known limitation of SharePoint. We cannot use file name in calculated column formula.
There is a SharePoint UserVoice for this. You can vote here: Use filename in calculated field
Workaround:
Create a new text field & populate its value using workflow on item creation/update. Hide this field from property forms.
Use workflow to updated the Title field based on the filename. Then use Title field in the calculated column formula.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Hi ganeshsanap, I've setup the workflow and got the filename to appear as Title for the document (see prints below). But, how to use Title field in the calculated column formula? I need to get this info in a specified cell inside the excel-doc. Could you please post some info on how to do this?
Many thanks,
Johan
Johan320 You cannot get SharePoint column information in cells inside excel file using SharePoint calculated columns. This is not possible using calculated column formula.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.