Could defining the function in Apps Script be a potential workaround in the meantime?
Apps Script is so convoluted and difficult to use. LAMBDA seems a straightforward feature with an obvious and immediate payback. Google’s Sheets PM should just schedule this.