During our previous startup, we faced the problem of using Google Sheets inefficiently, often writing app script code for what could be done with a couple of formulas owing to our lack of knowledge about spreadsheet functions.
So we built Tersho, an AI tool than can write formulas from simple English descriptions. It can also explain complicated formulas simply.
Behind the scenes, we are using OpenAI's Codex and a lot of prompt engineering involving knowledge about all the formulas and lots of labelled examples.
There's a live demo on our website (https://www.tersho.com) and we also have Excel and Google Sheets add-ins available for download.
Happy to hear feedback!