Share via

Use built-in named formulas in Excel layouts

  • Article
Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically - Oct 1, 2024

Business value

We're saving Excel report authors time and energy by providing built-in named formulas that make it easy to access data from metadata sheets.

Feature details

To make it easier to use data from metadata sheets, named formulas are now built in to Excel layout workbooks (when generated in 2024 release wave 2). Instead of taking time to develop complicated VLOOKUP or XLOOKUP formulas, report authors can use named formulas, such as ReportRequest.Date or ReportMetaData.ReportHelpLink.

Named formulas included in Excel layout workbooks