Forum Discussion
How to use Version in a calculated column?
- Apr 13, 2023
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
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