I'm learning a new language and I recently discovered Google Sheets' GOOGLETRANSLATE
function. I thought it'd be neat to have a personal dictionary of translations which I can even annotate. So I created a simple sheet that translates words from column A in column B. So far so good.
The problem is I can't tell Google Sheets to "translate every cell in column A to column B". I used ARRAYFORMULA
but it doesn't work as expected. =ArrayFormula(GOOGLETRANSLATE(A2:A,"en","de"))
only results to
As you can see, only B2 is translated, not everything else.
FWIW, dragging the fill handle down still works but I want an endless dictionary of such translations. I created the sheet on the web app but I use it primarily via the Android app. I want to just type the word in column A and get its translation. Unfortunately, if the fill handle even works in mobile, I don't know how to trigger it. (And I know this forum is for web apps so I'm going to stop right there.)