Excel formula outputed through SQL are intepreted as text upon excel files opening and needs to be "activated" (select cell, press enter).
Woud be very nice to allow direct excel formula in report output.
Example : Create a clickable URL link in excel to an online place (sharepoint) where reports are stored.
-> Very useful in a "meta" report, that holds other reports name / description / type / count
We will review this but it comes down to what's possible in Excel and the third party plugin we use to support Excel integration. We will investigate and see what is possible.
There is a product accelerator available to download via the support site that can integrate with Sharepoint, OneDrive, Teams from a file perspective already.
In the existing HELP/ INSTRUCTIONs tab options in excel integration the implmentation team can put these sharepoint links in their spreadsheet already.