I’m working on translating content in Google Sheets from English to Italian and some other languages. The translation part is working fine, but I need to make sure each translated text doesn’t exceed 200 characters because of Amazon’s requirements.
How can I add a character limit to my translation formula? I want the translated text to be cut off at 200 characters maximum.
Right now I’m using a vlookup function to get the English text and then translate it. But I keep getting this error message:
Wrong number of arguments to IFERROR. Expected between 1 and 2 arguments, but got 3 arguments.
check if ur formula has any weird spaces or formatting. copy-pasting can mess things up. for the 200 char limit, just wrap ur formula with LEFT like this: =LEFT(your_formula_here,200). it works well for amazon, tho it might cut off some words awkwardly.
That error’s usually from syntax issues or hidden characters in your formula. Rebuild it step by step - test just the VLOOKUP first, then add GOOGLETRANSLATE, finally wrap with IFERROR. For the character limit, don’t just use LEFT - it cuts mid-word and looks choppy. I combine LEFT with TRIM for cleaner breaks: =TRIM(LEFT(iferror(GOOGLETRANSLATE(vlookup(B2,'Data Sheet'!A:Y,12,false),"en","it"),""),200)). TRIM removes trailing spaces from the cut-off. I use this for Amazon product descriptions and it handles character limits way better than hard cuts.
Your IFERROR formula looks fine, but there may be an issue elsewhere in your sheet. It’s a good idea to retype the formula to eliminate any invisible characters that might be causing trouble.
To impose a 200 character limit on your translation, you can use the LEFT function to wrap your existing formula like so:
This will ensure that translated text does not exceed 200 characters. Be aware that this method might cut off sentences abruptly. For neater breaks, consider using the FIND function to locate the last space before reaching your character limit.