Formulas are the hidden “alpha” feature from day one, as their scope is unspecified and there’s no user-friendly formula editor or documentation.
This is about making formulas available to all and polished, with a well-defined set of functions and properties, and a user-friendly formula editor with coloring, code completion and at least minimum description of parameters.
The current syntax is javascript-like as it’s pretty simple and universal.
It could be worth exploring using a subset of Excel functions as at least for some it may be something they understand well.