We used to use Content Type to drive retention for our documents but moved away from that and now use the Retention Label options in SharePoint so that staff can assign the correct retention policy for a document in a SharePoint Library.
When we used the Content Type, there was an Expiration Date column that would display the expiration date for each file in the library and the user could sort on that column. Unfortunately, the Retention Label option does not have an expiration date column to display.
We only have 2 retention labels for staff to choose from:
1. Business General (delete file after 5 years from the last Modified Date)
2. Contractual/Legal (delete file after 10 years from the last Modified Date)
I was thinking that I could add a calculated column to hold the expiration date and display it to the user in the SharePoint Library. Unfortunately, a calculated field cannot reference 2 fields to come up with the value.
If Retention Label equal "Business General" add 5y to Modified Date
If Retention Label equal "Contractual/Legal" add 10y to Modified Date
Otherwise leave blank
Is there something else that we can do? JSON perhaps? Is there an even better way to do this (BI Report on all Document Libraries on a single site displaying the expiration date in a sortable column)?