If you know some Spanish, you will notice that in fact some of the translations aren’t that good, or at least will depend on the situation. = iferror ( GOOGLETRANSLATE ( A2, “en”, “es” ), “” ) In cell C2 I’ve written the formula that has been used. In cell A2 and I have the problem reported by the teacher in English, then the translation will appear in cell B2. To show this, let’s look at a simple example below.

To do this, I used the GOOGLETRANSLATE function. We’re in Seville, Spain, and some teachers can’t speak Spanish very well, so I needed a system that would allow them to report the problems in English and then it would translate it into Spanish, so that the maintenance and IT guys, who don’t speak English, can understand the problems and act on them.

I created a system where I work, where teachers can report problems in their classrooms via Google Forms on their mobiles. So, in this post we’re going to look at the functions GOOGLETRANSLATE and DETECTLANGUAGE and you’ll see how easy these are to use.Įxample 1 – Translating from one language to another Lots of people know about and have used Google Translate either on their phones or on the Google website but what they often don’t know is that there is a built-in function in Google Sheets, which will allow you to translate from one language to another, and even automatically recognise the language and translate it.

Google translate filipino to english