Apex Code Development You need to sign in to do that
Don't have an account?
Sales Collateral Formula Link to display as URL link when export report to Excel
I've created a Formula field so that I can view the Opportunity ID URL link on Opp reports that we export over to Excel.
Formula Data is: LEFT($Api.Enterprise_Server_URL_340, FIND('/services', $Api.Enterprise_Server_URL_340)) + Id
This works well but when I export it over to Excel, I then have to double left click on the cell, then click on the cell below to make it into an actual URL link. How can I make it come over already as a URL link when I export the report please?
Formula Data is: LEFT($Api.Enterprise_Server_URL_340, FIND('/services', $Api.Enterprise_Server_URL_340)) + Id
This works well but when I export it over to Excel, I then have to double left click on the cell, then click on the cell below to make it into an actual URL link. How can I make it come over already as a URL link when I export the report please?