[F] Ability to add a formula within the Name Manager

Feature Proposal

Currently, it's possible to add a range to the name manager wb.definedNames.add('Sheet1!A2:A6', 'myName', but it's not possible to add a formula such as =INDEX(department_filter1_table,,MATCH(department,departments_list,0)).

Motivation

This would allow us to create scalable solutions such as many dynamic dropdowns which can all be based off of different parents. At the moment, the only possible way to do this is to create a cell with the dynamic data for every single dynamic dropdown (discussion). This isn't efficient/viable for a large workbook.

Example

It would open up the ability for all sorts of dynamic data use cases. Here is a use-case for a dynamic dropdown.

Formulas within the Name Manager

Filter 1 & 2 dropdown options change based on the department selected

I've spent days trying to figure out a workaround for this, but I've come to the conclusion that this just isn't possible with the current ExcelJS functionality.

Thanks for reading, Jonathan