Forum Discussion

NastaraN's avatar
NastaraN
Copper Contributor
Apr 13, 2023

How to use Version in a calculated column?

  Hi, I want to use the version number in a calculated metadata column, however, it doesn’t show up in the list. I am trying to make a calculated column for the file name in SharePoint Document Li...
  • kalpeshvaghela's avatar
    Apr 13, 2023

    NastaraN 

     

    As per my understanding, In calculated column we can't use OOTB Version column.

    But there is one classic feature (Which is still available in SharePoint Online) which you can use i.e. Labels from Information Management Policy. Following are the steps to do so.

     

    • Activate Site Collection Level Feature with Name "Library and Folder Based Retention".

     

    • Go to library settings and click on Information Management Policy Settings

     

    • Click on Document Content type (If you have multiple content type then you need to configure for each content types)

     

    • Check on Enable Labels and Define Label Format (You need to use SharePoint Column's Display Name Here). In below screen shot "Version" and "Title" is default column and "Document Number" is custom column. . After adding Label Format click on Refresh button and then click on OK button.

     

     

     

    After performing above steps, one column with Label will be created automatically in library and you can add it in view, and SharePoint will calculation it's value based on given Label Form.

     

     

    Limitation:

    • If you document library does have already uploaded document then it will not apply this label by default. (I am not sure whether it's default behavior or bug in SharePoint). For Existing document if you update it manually then label will be applied.

     


    Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community

     

     

     

Resources