Reports - Clickable Case Number Links in Excel Exports
The Matter/Case ID# column in reports displays a nicely clickable link to each case. But if you export the report to Excel, the underlying URL doesn't come along.
There are various solutions for this. Here is one that was posted to the Siteadmins mailing list:
Add the case's Database ID to your report, in addition to the case number, preferably as the final column.
In Excel, in the column immediately to the right of the database ID, enter this formula, replacing the URL and cell column/row with your own info:
=HYPERLINK(CONCAT("case profile url minus the last digits",DATABASEID1))
as an example, it would look like this:
Then extend the formula through the remaining rows of the column.
Thanks to SV at LAFLA for this contribution.