How do I make the formula work?

Ask for Help
1

When adding rows to Google Spreadsheet, I want it to be translated for each column.
If you paste, a row is added below and the formula cannot be applied.
How do I make the formula work?

20230928_133519
20230928_1335192750×146 33.9 KB

2

When adding rows to Google Spreadsheet, I want it to be translated for each column.
If you paste, a row is added below and the formula cannot be applied.
How do I make the formula work?

3

What formula are you using to translate the words?

4

Translation is done by googletranslate.

2023년 9월 29일 (금) 오전 10:23, Thịnh Đinh via Glide Community <notifications@glideapps.discoursemail.com>님이 작성:

5

Please use the BYROW function to make it work on every row.

It would look like.

={“Translation”;BYROW(A2:A,LAMBDA(x,IF(x=“”,“”,GOOGLETRANSLATE(x,“lang1”,“llang2”))))}

1 Like
6

To apply a formula to new rows in a Google Spreadsheet, use the “fill down” feature. Enter the formula in the first row, then drag the fill handle down to the last row where the formula should be applied. Alternatively, select the entire column and use the keyboard shortcut “Ctrl + D” (Windows) or “Command + D” (Mac) to fill down the formula to all the cells in that column. This will ensure the formula is applied to new rows, translating the data automatically.

7

This should not be recommended. Arrayformula/Byrow works best, because if you use the method mentioned, if there are rows beyond the original range, the formula won’t be applied.