Re:Array Languages vs. the Curse of the Spreadsheet
by threePointFive on Tuesday March 05, 2024 @06:27PM
(#39610409)
You've been able to write custom formulas in VBA in Excel for a while now. The same functionality exists in Google Sheets with the much nicer macro language of JavaScript.
https://developers.google.com/apps-script/guides/sheets/func...
A 2nd improvement I would go for would be to allow the cell-formula to be written in JavaScript.